between function?
"klh84" wrote:
=if(AM7(is between 0.005 and 0.999),"etc","etc")
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 -----
"klh84" wrote:
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?
|