"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