Rounding up results

[mistral]

Have problem rouinding up result:

Some calculation, the worksheet last column contain the following formulas, from top to bottom:


=E17*F17
=E18*F18

=SUM(G17:G28) (subtotal)


=ROUND(IF(G30=0;G29;(1-G30/100)*G29);2)


=G29*0.18 (VAT)


=G31+G33 (Total)


Total show 709.99, I need get 710.00



Thanks.

 

[Pete_UK]

Instead of:

=ROUND(IF(G30=0;G29;(1-G30/100)*G29);2)

you could have:

=ROUNDUP(IF(G30=0;G29;(1-G30/100)*G29);2)

Hope this helps.

Pete

 

[MartinW]

Also, you may want to look at Tools>Options>Calculation
and check 'precision as displayed'. However be careful
as this is a global change that affects all calcs.

HTH
Martin

 

[MartinW]

I should add that it is irreversible so you should
try it on a copy first.

HTH
Martin

 

[mistral]

Instead of:

you could have:

Hope this helps.

mistral wrote:

Have problem rouinding up result:

Some calculation, the worksheet last column contain the following formulas,
from top to bottom:


=E17*F17
=E18*F18

=SUM(G17:G28) (subtotal)


=ROUND(IF(G30=0;G29;(1-G30/100)*G29);2)


=G29*0.18 (VAT)


=G31+G33 (Total)


Total show 709.99, I need get 710.00



Thanks.
---------------------------------------------

I meant last cell, 'Total' - where I need get full number (710.00) instead
of 709.99

=ROUND(IF(G30=0;G29;(1-G30/100)*G29);2) --> this formula calculate discount,
but I have no discount there.

G17 cell - formula is =E17*F17
G18 cell - =E18*F18

G29 cell - =SUM(G17:G28)
G31 cell - =ROUND(IF(G30=0;G29;(1-G30/100)*G29);2)
G33 cell - =G29*0.18
G34 cell - =G31+G33