Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell locations with formula?
I have been trying to create worksheets for my students using Excel but I
would like to use the local language instead of actual numbers. I have typed in the words for each number and have been trying to link the numerical value in one cell so that it places the word version in another. If for instance I have my words in column A and I have created simple math problems using numbers. Is there a way to have excel use the number in my math problem to tell which cell in column A to insert the word from? I was using if then formula but it is limited to 7 statements. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell locations with formula?
Try Debra's nice coverage on VLOOKUP at her:
http://www.contextures.com/xlFunctions02.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Trevor" wrote: I have been trying to create worksheets for my students using Excel but I would like to use the local language instead of actual numbers. I have typed in the words for each number and have been trying to link the numerical value in one cell so that it places the word version in another. If for instance I have my words in column A and I have created simple math problems using numbers. Is there a way to have excel use the number in my math problem to tell which cell in column A to insert the word from? I was using if then formula but it is limited to 7 statements. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for changing colour of a cell based on Neumeric VALUE | Excel Discussion (Misc queries) | |||
Changing a cell reference within a formula w/another cell | Excel Worksheet Functions | |||
Changing Formula Locations | Excel Discussion (Misc queries) | |||
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |