RoundDown Formula

janacs123

New member
Joined
Oct 9, 2015
Messages
2
Reaction score
0
Points
0
Hi Team,

Please clarify the below things,

Formula: (50000*(1+0.019))-46375

Actual Result : 4575

Excel Result when i implement ROUNDDOWN((50000*(1+0.019))-46375, 0) is, 4574. It should be 4575 only..

Thanks.
 
Try
Code:
=ROUNDDOWN(((50000*(1+0.019))-46375)*1.00000000001,0)
 
if you take your first formula in a cell and expand the decimal places out 8 or 10 places using formatting, you will see that your number is actually
4,574.99999999999000000000000

This a known quirk of Excel for many years.

Hope this helps!

Here's one site with info and some possible solutions:
https://support.microsoft.com/en-us/kb/78113
 
Last edited:
Back
Top