Excel Formula - Input Letter, Output Number

October 3, 2010 at 01:11:09
Specs: Windows Excel
Hi all,

I am a novice at excel and I would appreciate help with a formula.
Here it is:
I would like a letter (eg D) that has been typed into A1, to indicate that the number (eg 12)
in B1 would be the value that formulates in C1 (eg 12).

Thank you very much for your time.
Linda D

See More: Excel Formula - Input Letter, Output Number

October 3, 2010 at 05:44:47
Not enough info. What would you want C1 to show if A1 is blank or contains something else than "D"?


Mobo: Asus P7P55D LE
OS: Microsoft Windows 7 Professional OEM
CPU: Core i5 750 @ 2.67 GHz
RAM: Corsair Dominator DHX+ DDR3 1600MH 4GB
GPU: Sapphire 4870 D

Report •

October 3, 2010 at 05:45:25
Here's a posting tip:

When posting in a Help forum please try to use a subject line that gives us a little detail about your question. Considering the hundreds of questions posted in this forum, if everyone used a generic subject line such as "Excel Formula" we wouldn't be able to tell one question from another.

I have edited the subject line for this question.

Office Forum Moderator

Report •

October 3, 2010 at 05:48:39
I'm confused as to the relationship of B1 to C1. Please explain that a little further.

In addition, is there relationship between your example data, D & 12? What if A1 contains Z or Fred or 99 etc.

Report •

Related Solutions

October 3, 2010 at 14:46:57
Apologies and thank you for the replies and suggestions.

I am creating a time line table for a history project.
I want to be able to type in box A1 b for birth, d for death, m for military etc
In B1 and C1 there will be the dates and in D1 there will be a calculation of the time frame.ie A1 (m for military) B1 (10/10/1918) C1 (10/10/1919) D1 365 (days)

Consider line N is my timeline line.
I would like to have a formula that because I have typed M in A1 that the total in box D1 will appear in N1. Similarly, if I type in B in A1 the total in D1 will appear in N5 or if I type D in A1 the total in D1 will appear in N4.

I hope this is a little clearer.
Thank you again,

Report •

October 3, 2010 at 15:56:10
re: "Consider line N is my timeline line"

Excel does not have "lines". It has Columns and Rows. I assume you mean Column N.

In each of your cells, N1, N4 and N5 try these formula:

N1: =IF(A1="M", D1, "")
N4: =IF(A1="D", D1, "")
N5: =IF(A1="B", D1, "")

Report •

October 3, 2010 at 23:25:39
Thank you Derbydad,

That is working perfectly for me.
I very much appreciate your help and will endeavor to get going an excel

Again much appreciated, till next time.

Report •

Ask Question