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
|