Quote:
Originally Posted by louise1989
...can i make the net and vat automatically round up to the nearest penny ??
|
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)