I would prefer the following, which gives the same result:
=IF(AND(B3="ADMIN",C3="FHS"),3.5,0)+IF(AND(B3="ADM IN",C3="CMS"),9,0)+IF(AND(B3="ADMIN",C3="FMS"),0.2 ,0)+IF(AND(B3="ADMIN",C3="LOR"),0.8,0)+IF(AND(B3=" ADMIN",C3="ABR"),10,0)+IF(AND(B3="ADMIN",C3="ARA") ,1,0)+IF(AND(B3="ADMIN",C3="PAT"),9.2,0)

"Tech_in_the_woods" wrote:

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="ADMIN",C3="FMS"),0.2,IF(AN D(B3="ADMIN",C3="LOR"),0.8,IF(AND(B3="ADMIN",C3="A BR"),10,IF(AND(B3="ADMIN",C3="ARA"),1,IF(AND(B3="A DMIN",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?!?!