If function and a range

  • Thread starter Thread starter mrsatroy
  • Start date Start date
M

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"))))
 
=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")
 
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
 
Back
Top