Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I have words representing numbers in a formula?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I have words representing numbers in a formula?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I have words representing numbers in a formula?
Should be relatively easy using the VLOOKUP function. You would need to set
up a table listing your codes, and the appropriate mileage for each in the next column to the right. Say your list was in D1:E25, and the code you wanted to look up was in A1, then something like this in B1 should work fine....... =VLOOKUP(A1,D1:E25,2,FALSE) hth Vaya con Dios, Chuck, CABGx3 "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I have words representing numbers in a formula?
Yes, in a way. You could name a cell or a range of cells -
Click on - <Insert<Name<Define Type the name Click on <OK If you had a cells named ABC and DEF you could add the cells by typing the formula =ABC+DEF Hope this helps. Regards. Bill Ridgeway Computer Solutions "PeterM" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I have words representing numbers in a formula?
Many thanks to you for the help, Wiley, CLR and Bill. I'm on the road,
making the rounds. I will answer back tonight...PeterM "Bill Ridgeway" wrote in message ... Yes, in a way. You could name a cell or a range of cells - Click on - <Insert<Name<Define Type the name Click on <OK If you had a cells named ABC and DEF you could add the cells by typing the formula =ABC+DEF Hope this helps. Regards. Bill Ridgeway Computer Solutions "PeterM" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |