My 4 row formula is not ROUNDING out

S

stacey robinson

Row D Row E Row F Row G
$120.00 $11.67 $10.32 $185.70
120 =(D16/18)+5 =(D16/18)+3.65 =F16*18

These are my 4 rows of cells. Top row shows my results the bottom row shows my formulas. My 4th row formula is not rounding out properly. How can I get this to fix?
 
J

joeu2004

stacey robinson said:
Row D Row E Row F Row G
$120.00 $11.67 $10.32 $185.70
120 =(D16/18)+5 =(D16/18)+3.65 =F16*18 [....]
My 4th row formula is not rounding out properly.

E16: =ROUND(D16/18+5,2)
F16: =ROUND(D16/18+3.65,2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top