Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I MAKE A WORD HAVE A VALUE IN EXCEL
I work on commission. what I sell decides the percentage. I want to know if I
can make a word have a value in excel. if i type the word, will it know the value? a1 a2 a3 a4 Item Sold Initial Renewal Commission tcntl $994 $279 pspec $479 tcprot $279 tcntl = 15% pspec = 10% tcprot = 10% a1*a2=a4 hope this makes sense |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I MAKE A WORD HAVE A VALUE IN EXCEL
I don't know if understand you completely, but it
looks like you need to lookup your words with the vlookup or the hlookup in a matrix, where your words are in column a and the value is in column b for example: A4 = vlookup(A1,sheet2!$A$1:$B$5,2,false) * A2 hth Carlo On Dec 5, 3:37 pm, madmhaha wrote: I work on commission. what I sell decides the percentage. I want to know if I can make a word have a value in excel. if i type the word, will it know the value? a1 a2 a3 a4 Item Sold Initial Renewal Commission tcntl $994 $279 pspec $479 tcprot $279 tcntl = 15% pspec = 10% tcprot = 10% a1*a2=a4 hope this makes sense |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I MAKE A WORD HAVE A VALUE IN EXCEL
InsertNameDefine
In the Names in workbook box, type tcntl In the Refers to box, type =15% =A1*tcntl gives the result -- Kind regards, Niek Otten Microsoft MVP - Excel "madmhaha" wrote in message ... |I work on commission. what I sell decides the percentage. I want to know if I | can make a word have a value in excel. if i type the word, will it know the | value? | | a1 a2 a3 a4 | Item Sold Initial Renewal Commission | | tcntl $994 $279 | pspec $479 | tcprot $279 | | tcntl = 15% | pspec = 10% | tcprot = 10% | | a1*a2=a4 | | hope this makes sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I MAKE A CELL OR WORD FLASH IN EXCEL? | Excel Discussion (Misc queries) | |||
How do I make an address label in excel, then merge it with Word. | Excel Discussion (Misc queries) | |||
Can you make a tab entry form in excel like you can in word | Excel Worksheet Functions | |||
Make Excel Table fit into Word Doucument | New Users to Excel | |||
HOW TO MAKE A EXCEL & WORD FILE IN RECOGNIZABLE FORMAT | Excel Discussion (Misc queries) |