If function and a range

[mrsatroy]

I have the following function and it is only half working for me as my
arguements seem to contradict one another as I want to see if my number falls
within a specified range. Any suggestions appreciated

=IF(F3<2,"Fail",IF(F3>2,"Pass",IF(F3>16,"Fail",IF(F3<16,"Pass"))))

 

[T. Valko]

=IF(F3<2,"Fail",IF(F3>2,"Pass",IF(F3>16,"Fail",IF(F3<16,"Pass"))))

Here's what your formula is "saying" :

=IF(AND(F3>2,F3<16),"Pass","Fail")

 

[Bob Phillips]

How about this

=IF(OR(2>16,F2<2),"Fail","Pass")

 

[Francis]

would you describe what you want to achieve by providing an example?
--
Hope this help

Please click the Yes button below if this post have helped answer your needs

Thank You

cheers, francis

 

[Bob Phillips]

That first 2 should be F2 not just 2.