Linda D. October 3, 2010 at 01:11:09 Specs: Windows Excel
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).
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.
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
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.