Thread: IF Function not working
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
DaveO[_2_] DaveO[_2_] is offline
external usenet poster
  
Posts: 46
Default IF Function not working
My apologies, some modification to your formula is required as well.
Please try this one:
=IF(Q13<=0.1,"good",IF(AND(Q130.1,Q13<0.2),"fair" ,"poor"))

Reply With QuoteReply With Quote