| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I assign a value to an Alpha character in order to do calc
-- Gail |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a value to an Alpha character in order to do calc
Need more info
"Gail" wrote: -- Gail |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a value to an Alpha character in order to do calc
Try this,
select a cell then Insert|Name|Define call the cell (say) A. Click Ok repeat this and call the next cell B Put a value in each of those cells and then try the formula =A*B Mike "Gail" wrote: -- Gail |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I assign a value to an Alpha character in order to do calc
Assume A to Z in D1:D26 and 1 to 26 in E1:E26
In B1 enter =LOOKUP($A1,$D$1:$D$26,$E$1:$E$26) Enter a letter in A1 to return a number in B1 which you can calculate with. Gord Dibben MS Excel MVP On Sat, 4 Oct 2008 08:27:00 -0700, Gail wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent alpha character in numeric cell | Excel Discussion (Misc queries) | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
| Parsing a alpha character out of a cell | Excel Worksheet Functions | |||
| Numerical grade to Alpha character | Excel Discussion (Misc queries) | |||
Linear Mode
