between function?

  • Thread starter Thread starter klh84
  • Start date Start date
K

klh84

I am trying to write an if function to find out if a value falls between two
numbers

=if(AM7(is between 0.005 and 0.999),"etc","etc")

Is there a function I can use to make this happen?
 
klh84 said:
=if(AM7(is between 0.005 and 0.999),"etc","etc")
Click to expand...

Ostensibly, you might want:

=if(and(0.005<=AM7,AM7<=0.999),"etc1","etc2")

But beware of such comparisons. Most decimal fractions, and those in
particular, cannot be represented exactly. Moreover, if AM7 is formatted as
Number with 3 decimal places, a number like 0.9991 might __appear__ to be
0.999, but it will fail the "between" test.

It would be better to write:

=if(and(0.005<=round(AM7,3),round(AM7,3)<=0.999), "etc1","etc2")

Even better: if AM73 can be =round(formula,3), then the first comparison
will work as intended.


----- original message -----
 
Back
Top