View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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