The output messages need to be enclosed in quotes...

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

--
HTH...

Jim Thomlinson


"Loren" wrote:

I'm putting this function in cell S13:

=IF(Q13="","",IF(Q13<0.1,good,IF(Q130.1<0.2,FAIR, POOR)))
I want GOOD for anything from 0 to 10%, FAIR for anything over 10% up to
20% and POOR for anything above 20%. What am I doing wrong?

No matter what I put in cell Q13, what shows up in cell S13 is - #NAME
- Why?
--
Loren