between function?
 

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?

between function?
 

Hi,
you can use

=if(and(AM7+0.005,AM7<=0.999),etc,etc)

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

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?

between function?
 

Use the AND function:

=IF(AND(AM7=0.005,AM7<=0.999),"etc","etc")

--
Biff
Microsoft Excel MVP


"klh84" wrote in message
...
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?