Simple Calculation error

  • Thread starter Thread starter conger1906
  • Start date Start date
C

conger1906

I have a formula "=IF((D33-E33)<=0.6,350,510)" - for some reason for certain
numbers (and these are simple) if the answer is 0.6 the formula gives the
false answer not the true answer. But not always. If the numbers are 65 and
64.40 the calculation gives the correct answer. If the numbers are 64 and
63.40 the calculation gives the incorrect answer. Seems a pretty basic
formula to me! Any reasonable explanation for this?
 
I can't give an exact explanation, but this workaround works:
=IF(ROUND(D33-E33,1)<=0.6,350,510)

--
Regards!
Stefi



„conger1906†ezt írta:
 
Back
Top