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

Not enough info. What would you want C1 to show if A1 is blank or contains something else than "D"? Nigel

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

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.

DerbyDad03

Office Forum Moderator

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.

Hi,

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,

Linda

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, "")

Thank you Derbydad, That is working perfectly for me.

I very much appreciate your help and will endeavor to get going an excel

course.Again much appreciated, till next time.

Linda

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History