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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum and Divide Formula error 7
CUMIPMT 0
#Value Error 6
Excel errors in multiplication 1
excel adding error? 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Excel DateDif - why does 2007 seem different? 3
rounding errors 1

Back
Top