View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
garron garron is offline
external usenet poster
 
Posts: 2
Default 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?