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