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
|