If function and a range
 

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(F32,"Pass",IF(F316,"Fail",IF( F3<16,"Pass"))))
--
mrsatroy

If function and a range
 

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

Here's what your formula is "saying" :

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

--
Biff
Microsoft Excel MVP


"mrsatroy" wrote in message
...
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(F32,"Pass",IF(F316,"Fail",IF( F3<16,"Pass"))))
--
mrsatroy

If function and a range
 

How about this

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

--

HTH

Bob

"mrsatroy" wrote in message
...
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(F32,"Pass",IF(F316,"Fail",IF( F3<16,"Pass"))))
--
mrsatroy

If function and a range
 

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





"mrsatroy" wrote:

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(F32,"Pass",IF(F316,"Fail",IF( F3<16,"Pass"))))
--
mrsatroy

If function and a range
 

That first 2 should be F2 not just 2.

--

HTH

Bob

"Bob Phillips" wrote in message
...
How about this

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

--

HTH

Bob

"mrsatroy" wrote in message
...
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(F32,"Pass",IF(F316,"Fail",IF( F3<16,"Pass"))))
--
mrsatroy