Create a complex formula
 

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????

Create a complex formula
 

Hi,

Try this

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

Mike

"Workin girl" wrote:

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????

Create a complex formula
 

What would we put if the sum is 2-23 or above 30?

Try this:
=if(and(sum(A1:A20)=28,sum(A1:A20)<=30),"Great",i f(and(sum(A1:A20)=24,sum
(A1:A20)<=27),"Better",if(sum(A1:A20)<1,"Horrible" ,"NO COMMENT")))



Workin girl wrote:
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????

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1