Correcting formula

[mistral]

Have problem to round up result, total show 709.99, I need get 710.00
Formulas from last column(from top to bottom):

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) --> this formula
calculate discount(in G30 cell), cell empty, no data.

G33 cell - =G29*0.18
G34 cell - =G31+G33


thanks

 

[Niek Otten]

http://www.mcgimpsey.com/excel/pennyoff.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Have problem to round up result, total show 709.99, I need get 710.00
| Formulas from last column(from top to bottom):
|
| 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) --> this formula
| calculate discount(in G30 cell), cell empty, no data.
|
| G33 cell - =G29*0.18
| G34 cell - =G31+G33
|
|
| thanks
|
|