Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
assign number value to text Excel
Name: Hellsbells Date: January 11, 2004 at 09:33:47 Pacific OS: Win95 CPU/Ram: 233
Comment:
i need to give letters a value for a shift rota, eg i need "N" to equal 11 and "LD" to equal 12. Each cell will have N or LD for different shifts, then i need to add up all in a row to give a total of hours worked. I can't find a formula that lets me give text a value like this! Would appreciate help!-
Name: dtech10 Date: January 11, 2004 at 15:02:22 Pacific
Reply:
Hi Excel has a function that's might help it's called CODE which returns the ascii value of the first letter character it finds. ie. code("A")=65 code("a")=97 you could do something like this. say A1=N and A2=LD then the formula =code(a1)-67+code(a2)-64 =11+12
0
Response Number 2
Name: J A Dean Date: January 11, 2004 at 15:49:40 Pacific
Reply:
I had a quick look at your problem and the easiest solution I could come up with was to use the COUNTIF function twice on each row, once to count the number of Ns and once to count the number of LDs. It is then simply a matter of multiplying the results of the countif by the values you assign to N and LD and adding them together.
Hope this helps.
0
Response Number 3
Name: Hellsbells Date: January 12, 2004 at 01:12:39 Pacific
Reply:
Thank you thank you thank you!! Have used response 2 (as haven't worked with ascii before) and it works perfectly. No longer have to add up 350 different cells on my calculator and should get correct hours worked first time!Thanks for input.
0
Response Number 4
Name: J A Dean Date: January 12, 2004 at 02:57:53 Pacific
Summary: I have a 10 step process for creating classes (10 columns). As each step is completed, an "X" is placed in the spreadsheet cell. How do I assign a 10% value to the "X" in the cell in the spreadsheet s...
Summary: Hi Everyone, This might be elementary but I have never used this function before and I need desperate help from you experts of Excel. I need to assign specific #s to specific value ranges. Example: Va...
Summary: I have a list of numbers and I want to convert all these numbers to text, is there any way or formula in excel to do so. For example I have (1) convert (one)2 (two) 3 (Three) and so on. I shall be gre...
0 
