Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
7 + if statements
I am trying to create an excel workseet that will allocate operating expenses
to 6 different departments. On a previous tab ( Alloc Table) I have 10 allocation methods, each with a letter assigned A thru J. On my Expense tab, in column E, I am assigning one of my allocation mehtods (by indicating one of my letters A thru J) to each expense line. I am then using if stamtents to choose the correct alloation rates and alloate the expenses. My formula is: =IF($E7="A",($D7*'Alloc Table'!E$7),if($E7="B"($D7*'Alloc Table'!E$10),.... and on to "H". However, my formula will not allow me to go beyond H ( 7 nested ) . Can anyone give me suggestions as to how I can include more then 7 if statemetns. As ypu can tell, I'm pretty basic here. Thanks Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statements | Excel Worksheet Functions | |||
If statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
using if statements | Excel Worksheet Functions | |||
if statements | Excel Worksheet Functions |