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
|