L
LavaDude
I don't know why excel is doing this... Any help (or explanation) would be
appreciated...
I have the following calculations:
D19 = 374,268.89
E19 = =ROUND(D19*0.07,2)
F19 = [left blank]
G19 = =-1881.75*12
H19 = =SUM(E19:G19)
I19 = 3617.74
J19 = =IF(H19<0,-I19,H19-I19)-0.08
FYI: Cell F19 is blank
Basically, H19 is showing $3,617.82 and I19 is $3,617.74, so the "-0.08" at
the end of the formula in J19 should make the calculation 0.00 ... But it's
showing "(0.00)" ... and when I increase the decimal places I see
(0.000000000000073) ... What's up with that? ...
The only cell that would cause rounding problems has been rounded to two
(2) decimal places (cell E19) ... Why would excel cause this type of
rounding to the 14th (or 15th) decimal place?
To solve the "(0.00)" ... I just added the round formula to J19, but I'm
wondering why excel does this...
TIA!!! ...
LavaDude...
appreciated...
I have the following calculations:
D19 = 374,268.89
E19 = =ROUND(D19*0.07,2)
F19 = [left blank]
G19 = =-1881.75*12
H19 = =SUM(E19:G19)
I19 = 3617.74
J19 = =IF(H19<0,-I19,H19-I19)-0.08
FYI: Cell F19 is blank
Basically, H19 is showing $3,617.82 and I19 is $3,617.74, so the "-0.08" at
the end of the formula in J19 should make the calculation 0.00 ... But it's
showing "(0.00)" ... and when I increase the decimal places I see
(0.000000000000073) ... What's up with that? ...
The only cell that would cause rounding problems has been rounded to two
(2) decimal places (cell E19) ... Why would excel cause this type of
rounding to the 14th (or 15th) decimal place?
To solve the "(0.00)" ... I just added the round formula to J19, but I'm
wondering why excel does this...
TIA!!! ...
LavaDude...