| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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???? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need complex if formula (I think) | Excel Worksheet Functions | |||
| How do you create a complex footer (e.g. title block) in Excel? | Excel Discussion (Misc queries) | |||
| Create a formula that contains a complex embedded IF statement | Excel Worksheet Functions | |||
| Complex If/Then formula? | Excel Discussion (Misc queries) | |||
| How do I create complex functions? | Excel Worksheet Functions | |||
Linear Mode
