You could set this up in a table, but would be looking at a lot fo formula
work to handle multiple destiantions in one trip. It seems to me that just
entering the milage would be easier.

Can you tell us how you would enter the data? An exampe of a round trip to
1 destination, vs round trip to mutliple destinations.

"PeterM" wrote:

I have several abbreviations representing numbers in a spreadsheet that I
like to automate. I have for instance MGT to VW representing 3 miles than
back to MGT then being 6 miles. Is there a way I can have a formula that can
read MGT VW MGT and that will give a 6 mile total count. I then also have
MGT AUDI ACURA BMW VW MGT. That is a trip I make with my car, and they all
add little mileage to my spreadsheet amounting to 19 miles total. MGT to
AUDI is 5 mi, AUDI to ACURA is 4 miles, ACURA to BMW is 6 miles, BMW to VW
is 1 mi, and the VW to MGT is 3 miles. There are more destinations, but once
I have the idea on how to do it, I can add the miles for different
places.......Peter