Forum Discussion
Solved
Stop Excel from Rounding to the Nearest Dollar Amount
39*$13.33 should = $519.87 NOT $520.00 I have searched relentlessly for help on this problem to no avail. My decimal points are set correctly, my column is wide enough, yet no matter what I do, t...
The issue lies in the rate in cell C21. Essentially you are taking $520 divided by 39 which actually gives an answer of 13.333... Then you multiply 13.333... again by 39 which gives you back your original $520.
You should use the following formula in cell C21 if you desire $519.87 as a result in cell D21:
=ROUND(E14/B21,2)Hope this helps!
PReagan
Hi,
The "Rate" column is wrongly set to "Accounting" format
Set it to General format>> Then in cell C21 type =Round(E14/B21,2)
Mind the Cell locking of E14 if you are copying this formula
Good Luck
Hope that helps
Nabil Mourad