# 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

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
|
|

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1