Simple Calculation error

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?
 
S

Stefi

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
excel adding error? 1
If function confused with 0.1 11
Formula nesting with IF statements 2
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Making Zeros look like no entry 5
#Value Error 6
Data Calculation 2

Top