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