# Correcting formula

1. ## Correcting formula

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  Register To Reply

2. ## Re: Correcting formula

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mistral" <mistral@mistral.net> wrote in message news:%23s44oBUvGHA.1296@TK2MSFTNGP02.phx.gbl...
| 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
|
|  Register To Reply