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

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516648

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 :-)
------------------------------*------------------------------*----------------


wrote in message
ups.com...
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