good, FAIR and POOR must be enclosed in double quotes.

"good" etc.


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 10:34:00 -0800, Loren
wrote:

=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(F AIR),(POOR))))

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