Solve : Office Excel Formulae?

1.	Solve : Office Excel Formulae?
Answer» Does anyone know how to get Excel to reference text as a value e.g. So that I can type 'Value_1' in cell A1 and have cell B1 return the number assigned to that text. _____________________ ¦ A ¦ B ¦ C ¦ 1¦ V1 ¦ 2 ¦ ¦ 2¦ ¦ ¦ ¦ I'm trying to make a table were I can type various two letter codes and get a number return for the total at the end of the week. So the sum of V1, V2, V3 but I need to know how to reference values 1-3 to numbers.I'm POSTING two images from Excel to show what I came up with. The second one SHOWS the forumulas. [Saving space, attachment deleted by admin]Nearly what I'm after (sorry it was late and I was tired last night whilst trying to post the question). I need letters (text) to represent numerical data, but I want to keep the text entry displayed. So I want 'V1' to represent 2 but still display 'V1' in the cell.Quote from: Accessless on March 23, 2010, 10:47:06 AM Nearly what I'm after (sorry it was late and I was tired last night whilst trying to post the question). I need letters (text) to represent numerical data, but I want to keep the text entry displayed. So I want 'V1' to represent 2 but still display 'V1' in the cell. formula: =VALUE(RIGHT(A1,LEN(A1)-1)) this will get the "number" from A1, ignoring the first letter, so V1 becomes 1, V2 becomes 2, etc. No no, the V1 was just my example tag name. The values will be initials in the spread sheet that I'm working on, so no numbers. Just a thought here, is it possible to CREATE a SUM at the end of the row that recognises the initials as numbers (I don't know how it would work but) e.g. =SUM(A1:D1) IF AB= 2 IF AC=3, etc. Basically what I'm asking is can Excel do algebra? (If not then the Values for the initials are stored in a little table to one side of the main)

Answer»

Does anyone know how to get Excel to reference text as a value e.g. So that I can type 'Value_1' in cell A1 and have cell B1 return the number assigned to that text.
_____________________
¦ A ¦ B ¦ C ¦
1¦ V1 ¦ 2 ¦ ¦
2¦ ¦ ¦ ¦

I'm trying to make a table were I can type various two letter codes and get a number return for the total at the end of the week. So the sum of V1, V2, V3 but I need to know how to reference values 1-3 to numbers.I'm POSTING two images from Excel to show what I came up with. The second one SHOWS the forumulas.

[Saving space, attachment deleted by admin]Nearly what I'm after (sorry it was late and I was tired last night whilst trying to post the question). I need letters (text) to represent numerical data, but I want to keep the text entry displayed. So I want 'V1' to represent 2 but still display 'V1' in the cell.Quote from: Accessless on March 23, 2010, 10:47:06 AM

Nearly what I'm after (sorry it was late and I was tired last night whilst trying to post the question). I need letters (text) to represent numerical data, but I want to keep the text entry displayed. So I want 'V1' to represent 2 but still display 'V1' in the cell.

formula:

=VALUE(RIGHT(A1,LEN(A1)-1))

this will get the "number" from A1, ignoring the first letter, so V1 becomes 1, V2 becomes 2, etc.
No no, the V1 was just my example tag name. The values will be initials in the spread sheet that I'm working on, so no numbers. Just a thought here, is it possible to CREATE a SUM at the end of the row that recognises the initials as numbers (I don't know how it would work but) e.g. =SUM(A1:D1) IF AB= 2 IF AC=3, etc.

Basically what I'm asking is can Excel do algebra?

(If not then the Values for the initials are stored in a little table to one side of the main)

Solve : Office Excel Formulae?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment