|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 16th, 2008, 11:08 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
September 16th, 2008, 11:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#3
September 16th, 2008, 11:15 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#4
September 16th, 2008, 11:30 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#5
September 16th, 2008, 11:37 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#6
September 16th, 2008, 11:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
