IF Statement Help please

[mark]

I am trying to write an If statement for the following example:

If number is <18.44 write "FAIL", If Number >20.44 Write "FAIL", If Number
is between 18.44 and 20.44 then write "Pass"

I would appreciate any help on this, thanks Mark

 

[Ron Coderre]

Try something like this:
=IF(OR(A1<18.44,A1>20),"FAIL","Pass")

Does that help?

••••••••••
Regards,
Ron

 

[mark]

thanks works great!!!!

Try something like this:
=IF(OR(A1<18.44,A1>20),"FAIL","Pass")

Does that help?

••••••••••
Regards,
Ron