Forum Discussion
Stop Excel from Rounding to the Nearest Dollar Amount
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
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
You are a life saver!PReagan
Thank you so much. If you have a minute, can you explain that formula briefly. I would never have quessed to pick ROUND and the "2" must be the places?
- Precisely! The syntax for ROUND() is ROUND(number,num_digits). So simply ROUND() rounds a number to a total of num_digits.