=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