Values

D

dbasco

Is there a way to make a letter have an assigned numerical value.
Example: If the letter P is entered into a blovk then it will be
recognized as 12.25.
 
C

Chip Pearson

Go to the Insert menu, choose Name, then Define. Enter P in the "Names In
Workbook" box and enter your numeric value in the "Refers to" box. You can
then do formulas like

=P+1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
D

dbasco

Thanks that helped but I ran into another problem.

Cycle 1 Jan. 1- Jan. 14
1/1 Status OT TD 1/8 Status OT TD
1/2 1/9
1/3 1/10 5
1/4 1/11
1/5 1/12
1/6 1/13
1/7 1/14
Totals Reg. 0 OT TD
Hol. Sick

In the status column is where the letter P will be entered. At the 0
next to regular hours, I need P to enter in the formula along with
other number values that are present. An example would be at 1/2-P, at
1/4-8. So next to Reg. should be the #20.25. I cannot get this
portion to work.
 
D

David Biddulph

If P is meant to represent 12.25, why do you expect the formula 1/2-P to
represent 20.25?
I would expect 1/2-P to give -11.75.

Also, I didn't understand what you meant by "at 1/4-8"?

Exactly what formula have you put in the cell?
 
J

joeu2004

Thanks that helped but I ran into another problem.
Cycle 1 Jan. 1- Jan. 14
1/1 Status OT TD 1/8 Status OT TD
1/2 1/9
[....]
1/7 1/14
Totals Reg. 0 OT TD
Hol. Sick
In the status column is where the letter P will be entered. At the 0
next to regular hours, I need P to enter in the formula along with
other number values that are present. An example would be at 1/2-P, at
1/4-8. So next to Reg. should be the #20.25. I cannot get this
portion to work.
Click to expand...

First, I am not sure you fully understand what Chip suggested. You
would enter =P in the appropriate cell in the Status column, not simply
P. You will see 12.25, not P. Is that what you truly wanted?

Second, I presume that what you want in the cell next to Reg is
something like:

=sum(B2:B8,F2:F8)

where B2:B8 and F2:F8 are the Status cells for the dates 1/1 through
1/7 and 1/8 through 1/14 respectively. Thus, if you have =P in the
Status cell for 1/2 and 8 in the Status cell for 1/4, the sum will be
20.25.
 
Top