| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign a short cut key for user defined word? | Excel Discussion (Misc queries) | |||
| Can I assign a number to a name and use the name in a sum? | Excel Discussion (Misc queries) | |||
| Assign one number to a number range | New Users to Excel | |||
| Assign a number to a name | Excel Worksheet Functions | |||
| How can I assign a number to a string? | Excel Discussion (Misc queries) | |||
Hybrid Mode
