Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF statements
In an ideal world I would do a 22 nested If statement to check but
unfortunately Excel 2000 will only allow 7. What I have is a random subset of 5 values from 22 possibilities. The "english" for the formula is like this: If A2 = "Fri" then If B2 = Medic, a+b, if B2 = Home, b+c, so on and so forth for 22 possible options. I am unfamiliar with VBA but am sure this is not that difficult an equation to programme. Any help would be appreciated. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested if statements | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
nested IF statements | Excel Worksheet Functions | |||
Nested if statements - is there a better way? | Excel Worksheet Functions | |||
Nested If Statements | Excel Worksheet Functions |