View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default IF Function not working

Try putting double quotes around "good", "FAIR", and "POOR".
Will

"Loren" wrote:

I want cell S13 to give a certain answer depending on the value in cell Q13 -
I.E.
IF cell Q13 value is .1 or less then S13 = GOOD IF cell Q13 value is .1
to .2 then cell S13 = FAIR and if cell Q13 value is greater than .2 cell S13
= POOR. Here's the equation I have now and all cell S13 will tell me is #NAME?
=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))
--
Loren