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?