Assign a number to a word
 

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.

Assign a number to a word
 

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

Mike

"Noob McKnownowt" wrote:

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.

Assign a number to a word
 

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" wrote:

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

Mike

"Noob McKnownowt" wrote:

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.

Assign a number to a word
 

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" wrote:

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" wrote:

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

Mike

"Noob McKnownowt" wrote:

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.

Assign a number to a word
 

Your a gent and a star, cheers pal.

Noob

"Mike H" wrote:

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" wrote:

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" wrote:

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

Mike

"Noob McKnownowt" wrote:

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.

Assign a number to a word
 

Your welcome


"Noob McKnownowt" wrote:

Your a gent and a star, cheers pal.

Noob

"Mike H" wrote:

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" wrote:

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" wrote:

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

Mike

"Noob McKnownowt" wrote:

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.