see if this idea helps
=IF(AND(B3="a",OR(C3="b",C3="c",C3="d")),1,2)

--
Don Guillett
SalesAid Software

"Tech_in_the_woods" wrote in
message ...
I am trying to create a mileage tracker sheet based upon a pre-set table
of
distances. I would like to be able to choose 2 different locations from
drop
down lists in 2 different columns, then have Excel input the mileage
between
them in a new column and eventually autosum the column. I tried this using
a
series of nested IFs then realized I would run into the 7 IF limit. My
problem is that I am not a developer and don't work in VB.
Here are the nested IF statements I was using: rather bulky but they
worked:


=IF(AND(B3="ADMIN",C3="FHS"),3.5,IF(AND(B3="ADMIN" ,C3="CMS"),9,IF(AND(B3="AD
MIN",C3="FMS"),0.2,IF(AND(B3="ADMIN",C3="LOR"),0.8 ,IF(AND(B3="ADMIN",C3="ABR
"),10,IF(AND(B3="ADMIN",C3="ARA"),1,IF(AND(B3="ADM IN",C3="PAT"),9.2)))))))

My problem is that I have to add 3 more ifs in this section alone, then
have
the same thing for the 10 other locations. any suggestions would be
appreciated.
--
You want me to do what?!?!