Quote:
Originally Posted by TheNorm
Try:
ROUNDUP(number,num_digits)
Replace number by your existing formula, and num_digits by 2
So, if cell G2 is currently:
=SUM(E2/117.5)*100
You add the ROUNDUP function as follows:
=ROUNDUP(SUM(E2/117.5)*100, 2)
|
Sorry can u say that again but dumb it down a bit as im thick when it comes to excel and formulars !