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

Hmm. Do you know how to create a simple function using VBA? I'm currently
busy with other things.

/Fredrik


"K.W.Martens" wrote in message
...
Here is the nested situation example:

=IF(AND(B25="Soccer",D25="English",E25="Standard") ,"123456789",(IF(AND(B25="
Hockey",D25="English",E25="Standard"),234567890,(I F(AND(B25="Football",D25="
English",E25="Standard"),345678901,(IF(AND(B25="Ba seball",D25="English",E25=
"Standard"),456789012,(IF(AND(B25="Basketball",D25 ="English",E25="Standard")
,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