"UNCCNU" wrote in message
...
I have calculations that will give me an average score somewhere between 0
and 4 for a number of items. I'm trying to build a formula that says "if
the
result is between 0 and 1", then write the word "poor" in the cell. If
between, 1 & 2 then "fair". If between 2 & 3, then "good". If between 3
&
4, then "excellent". I've tried variations of IF and AND formulas, but to
no
avail. My results are either an "error" or only the 1st (poor) and last
(excellent) options, but not "fair" or "good".

Anyone familiar with IF / AND formulas for multiple variables?

Try
=IF(A13,"excellent",IF(A12,"good",IF(A11,"fair" ,"poor")))

You may need to use "=" rather than "" depending which word you want on
the boundaries.

Stephen