Here is the nested situation example:
=IF(AND(B25="Soccer",D25="English",E25="Standard") ,"123456789",(IF(AND(B25="Hockey",D25="English",E2 5="Standard"),234567890,(IF(AND(B25="Football",D25 ="English",E25="Standard"),345678901,(IF(AND(B25=" Baseball",D25="English",E25="Standard"),456789012, (IF(AND(B25="Basketball",D25="English",E25="Standa rd"),567890123,(IF(AND(B25="Racing",D25="English", E25="Standard"),678901234,(IF(AND(B25="Wrestling", D25="English",E25="Standard"),789012345,"Special") ))))))))))))

Now.....This has to apply to more variables in the named cells, as well as
has to be able to be allocated to 11 more rows....there is a total (at
present) of 596 different scenerios.....HELP please




"Fredrik Wahlgren" wrote:


"K.W.Martens" wrote in message
...
Thanks for the info, but, how can I do it in VBA.....your comment "this
can
be done easily" intriqued me. Any suggestions would be appreciated.
Another
question....I don't really know if I am looking at a "nesting" situation.
Each circumstance within the cell is determined by the drop down lists.
So,
as an example, instead of "Hockey" in B25, it was "Soccer" it would give a
different result. It seems to me that I have an IF/OR situation.....but,
I
still haven't found an answer.



I missed the fact that you used these if statments in a drop down list. What
I meant is that it's easy and recommendable to replace complex logic in a
cell with a user defined function. I don't know if you can call such a
function from a drop down list but I guess it should be possible since you
can use IF. Do you understand how to create the nested functions. If you do,
you can post them to this newsgroup and ask for an equivalent implementation
under VBA.

/Fredrik