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?