View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrsatroy mrsatroy is offline
external usenet poster
 
Posts: 6
Default If function and a range

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