Assign a number to a word

[Noob McKnownowt]

Hello ladies and gentlemen,

when i first thought of this idea i didnt think it would be to diffcult to
produce, this initial thought has proven wrong

my problem is simple, i have created a table representing the days of the
week, in the following columns i have the amount of people and total hours,
such as;

day | people | Hours |
______________________________
monday | | |


what i want to do is input the amount of people and then have a result
calculated in the hours coloum, to do this i need to assign the word monday
with a numeric value i.e. 4.

so if i input 2 in the people column the result calculated in the hours
column would be 8.

houw can i do this, any assistance would be greatly appriciated.

the noob.

 

[Mike H]

Before attempting to answer this do Tuesday thru Sunday have values and if so
what?

Mike

 

[Noob McKnownowt]

yes, although most days have the same, these are;

mon - 11.5
tue - 11
wed - 11.5
thur - 11
fri - 11
sat - 11
sun - 11

HTH, thanks.

 

[Mike H]

Hi,

Build yourself a table somewhere out of the way that looks like this
Mon 11.5
Tue 11
Wed 11.5
Thu 11
Fri 11
Sat 11
Sun 11

My table is in L1 - M7 but it can be anywhere. The text in the table (Mon
etc) must be the same as uo enter in your table. Then use this formula

=B2*VLOOKUP(A2,L1:M7,2,FALSE)


Mike

 

[Noob McKnownowt]

Your a gent and a star, cheers pal.

Noob

Hi,

Build yourself a table somewhere out of the way that looks like this
Mon 11.5
Tue 11
Wed 11.5
Thu 11
Fri 11
Sat 11
Sun 11

My table is in L1 - M7 but it can be anywhere. The text in the table (Mon
etc) must be the same as uo enter in your table. Then use this formula

=B2*VLOOKUP(A2,L1:M7,2,FALSE)


Mike

 

[Mike H]

Your welcome

Your a gent and a star, cheers pal.

Noob