blewispunk
New Member
- Joined
- Mar 31, 2003
- Messages
- 12
Hello,
I'm trying to use the rounddown function and getting some odd results that seem like a bug but maybe I'm confused by the function.
I have
A1 = 0.110
A2 = 0.101
My function is =ROUNDDOWN(A1-A2,3)
I keep getting a result of 0.008 even though simple math should result in 0.009. I would think this would be due to extra digits being in cell A1 or A2 but the values entered are exactly as shown here. If I try different values it seems to be working correctly with other combinations I've tried but this one is goofy. When I change the calculation to =ROUNDDOWN(A1-A2,4) I get a result of 0.0089, so it is doing some incorrect math.
Any thoughts on this? I'm using Excel 2007.
I'm trying to use the rounddown function and getting some odd results that seem like a bug but maybe I'm confused by the function.
I have
A1 = 0.110
A2 = 0.101
My function is =ROUNDDOWN(A1-A2,3)
I keep getting a result of 0.008 even though simple math should result in 0.009. I would think this would be due to extra digits being in cell A1 or A2 but the values entered are exactly as shown here. If I try different values it seems to be working correctly with other combinations I've tried but this one is goofy. When I change the calculation to =ROUNDDOWN(A1-A2,4) I get a result of 0.0089, so it is doing some incorrect math.
Any thoughts on this? I'm using Excel 2007.