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.



"Fredrik Wahlgren" wrote:


"K.W.Martens" wrote in message
...
I'm stumped....What I and trying to do is set up multple IF situations
from
drop down lists. As an example:

=IF(AND(B25="Hockey",D25="English",E25="Standard") ,"123456789","Special")...
now
I want to say the IF it different it will be this, but IF it's different
again it will be this...and so on. I have already 48 circumstances. If I
knew VB, I'm sure there is a more realistic way to do this.

Any assistance will be greatly appreciated.

It seems as if you want to do nested IF's. Unfortunately, you can't have
more than 7 If statements in a cell. This can be done easily in VBA. See the
links below. For more links google Excel nested if

http://www.cpearson.com/excel/nested.htm
http://spreadsheets.about.com/cs/exc...tediffunct.htm

/ Fredrik