View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Won't give correct answer

Your text values need to be enclosed in "quotes". Also, the Q130.1<0.2
should just be Q13<0.2 since this would only be evaluated if Q13<0.1 is
FALSE. Try this:

=IF(Q13="","",IF(Q13<0.1,"(good)",IF(Q13<0.2,"(FAI R)","(POOR)")))

HTH,
Elkar

"Loren" wrote:

=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))

Cell Q13 = .33 but what shows up in this cell is #NAME? What am
I doing wrong?
--
Loren