Thread
:
Giving letters a numerical value, then adding the total.
View Single Post
#
12
Posted to microsoft.public.excel.misc
Richard in Stockholm[_2_]
external usenet poster
Posts: 8
Giving letters a numerical value, then adding the total.
That helps me on my way too - thank you
"Peo Sjoblom" wrote:
I gave you a single formula solution without having to go and define any
names
--
Regards,
Peo Sjoblom
"Richard in Stockholm" wrote
in message ...
Thanks - it's helped me part way - I discovered that I can use the sum
function with this - is there any way you can ?? rather than putting in
the
E+E /E*4 formula??
"David Biddulph" wrote:
Insert/ Name/ Define
E
refers to
=8.25
Insert/ Name/ Define
E_1
refers to
=8
If you use the formula =E+E_1, you'll get the result 16.25
If you use the formula =E+E+E+E (or =4*E), you'll get the answer 33.
--
David Biddulph
"Richard in Stockholm"
wrote
in message ...
Thank you for replying but I didn't really understand that - I'm a bit
slow
on the Excel wagon. Could you possibly expand ?? :-)
Richard
"David Biddulph" wrote:
Insert/ Name
--
David Biddulph
"Richard in Stockholm" <Richard in
wrote in message
...
I do a lot of timetables where we use letters of the alphabet to
represent
different shifts for example E = 8.25 hrs work, E1 = 8 hours. I
usually
do
all the timetables in excel. I was wondering how do I assign
numerical
values
to each letter/code so that it adds up the total time in one cell? I
want
the
letters to remain but for them to have numerical values and then
have
one
cell that adds up all the hours worked as a number.
For example if one person works E, E, E, E on four different days
(i.e.
8.25
hours on four different days/cells) how do I get excel to give E an
value
of
8.25 so that the box that adds up the total values shows the total
(33)?
Is there a function where I can give values to specific letters in a
block
rather than putting in a formula in each cell (if there is one of
course)
?
This sounds rather complicated but would save me a lot of work. I
would
be
sooooo grateful to anyone who could help me.
Reply With Quote
Richard in Stockholm[_2_]
View Public Profile
Find all posts by Richard in Stockholm[_2_]