Create a complex formula

[Workin girl]

I need to create a formula that would sum several cells and then with the
total of that sum if the sum is between say 28-30 then put "Great" or if the
sum is between say 24-27 then put "Better" of if the sum is below 1 the "
Horrible". How would I write a formula for this????

 

[Mike H]

Hi,

Try this

=LOOKUP(SUM(A1:A20),{1,24,28},{"Horrible","Better","Great"})

Mike