| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
shorten IF Statements
Can someone help me shorten the following IF statement, or give me something
simpler that will work. I have more conditions I'll need to add: =if(w22=11,sum(o9:y9),if(w22=10,sum(p9:y9),if(w22= 9,sum(q9:y9),if(w22=8,sum(r9:y9),if(w22=7,sum(s9:y 9),if(w22=6,sum(t9:y9),if(w22=5,sum(u9:y9),if(w22= 4,sum(v9:y9),if(w22=3,sum(w9:y9))))) I've been looking at this for so long, I can't think clearly! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
shorten IF Statements
=sum(offset(y9,1-w22,0,w22,1))
"Flanno" wrote: Can someone help me shorten the following IF statement, or give me something simpler that will work. I have more conditions I'll need to add: =if(w22=11,sum(o9:y9),if(w22=10,sum(p9:y9),if(w22= 9,sum(q9:y9),if(w22=8,sum(r9:y9),if(w22=7,sum(s9:y 9),if(w22=6,sum(t9:y9),if(w22=5,sum(u9:y9),if(w22= 4,sum(v9:y9),if(w22=3,sum(w9:y9))))) I've been looking at this for so long, I can't think clearly! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
shorten IF Statements
=SUM(Y9:INDEX(O9:Y9,12-W22))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Flanno" wrote in message ... Can someone help me shorten the following IF statement, or give me something simpler that will work. I have more conditions I'll need to add: =if(w22=11,sum(o9:y9),if(w22=10,sum(p9:y9),if(w22= 9,sum(q9:y9),if(w22=8,sum(r9:y9),if(w22=7,sum(s9:y 9),if(w22=6,sum(t9:y9),if(w22=5,sum(u9:y9),if(w22= 4,sum(v9:y9),if(w22=3,sum(w9:y9))))) I've been looking at this for so long, I can't think clearly! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
shorten IF Statements
TY! Perfect!
"Bob Phillips" wrote: =SUM(Y9:INDEX(O9:Y9,12-W22)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Flanno" wrote in message ... Can someone help me shorten the following IF statement, or give me something simpler that will work. I have more conditions I'll need to add: =if(w22=11,sum(o9:y9),if(w22=10,sum(p9:y9),if(w22= 9,sum(q9:y9),if(w22=8,sum(r9:y9),if(w22=7,sum(s9:y 9),if(w22=6,sum(t9:y9),if(w22=5,sum(u9:y9),if(w22= 4,sum(v9:y9),if(w22=3,sum(w9:y9))))) I've been looking at this for so long, I can't think clearly! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there away to shorten | Excel Worksheet Functions | |||
| Can I shorten this any? | Excel Worksheet Functions | |||
| Any way to shorten this up? | Excel Worksheet Functions | |||
| How do I shorten a number? | Excel Discussion (Misc queries) | |||
| Shorten A Name | Excel Discussion (Misc queries) | |||
Linear Mode
