My rounding error in a simple IF

  • Thread starter Thread starter garron
  • Start date Start date
G

garron

col:A col:B col:C col:D col:E
4.82 -.02 =4.80 vs 4.80 =0%
why am i getting an error here?
=if(A>0.10,(D-C)*100/C,0)

Im expecting a 0% difference between C AND D
IT SHOULD READ 0%
DOH! WHAT am i doing wrong here?
I GET A number anywhere from 0.03% to .09%
any tips to do this right?
 
Not quite following you on this...

Does "=4.80" mean that's a calculated value?

If so, the 4.80 may not be the true value of that cell. It may be something
like 4.80000000056889

You should probably round it off to 2 decimal places.
 
You should probably round it off to 2 decimal places.

Round it using the ROUND function. Don't just *format* it to show only 2
decimal places. Formatting is only for *display* purposes.
 
Back
Top