My rounding error in a simple IF
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(A0.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?
|