Create a complex formula

W

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

pogiman via OfficeKB.com

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",if(and(sum(A1:A20)>=24,sum
(A1:A20)<=27),"Better",if(sum(A1:A20)<1,"Horrible","NO COMMENT")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top