Nest IF statement workaround

[theresaluff]

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 need to propogate this down a table so need the cell references in
the formulas to increment


Any help would be appreciated.


Thank you

 

[davesexcel]

Hi, I am wondering if you could elaberate on this a little more, have
you thought of using a look-up formula??
There could be an easier solution

 

[Ken Wright]

In an ideal world you wouldn't even consider trying to use a nested If
because you would already know that VLOOKUP will do what you need much much
easier

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------