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?