software

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 quot;englishquot; for the formula is like this:If A2 = quot;Friquot; 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 incrementAny 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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=516648In 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 :-)
------------------------------*------------------------------*----------------gt; wrote in message ups.com...
gt; In an ideal world I would do a 22 nested If statement to check but
gt; unfortunately Excel 2000 will only allow 7.
gt;
gt; What I have is a random subset of 5 values from 22 possibilities.
gt;
gt;
gt; The quot;englishquot; for the formula is like this:
gt;
gt;
gt; If A2 = quot;Friquot; then If B2 = Medic, a b, if B2 = Home, b c, so on and so
gt; forth for 22 possible options.
gt;
gt;
gt; I need to propogate this down a table so need the cell references in
gt; the formulas to increment
gt;
gt;
gt; Any help would be appreciated.
gt;
gt;
gt; Thank you
gt;