help with excle formula

December 9, 2014 at 02:40:05
Specs: Windows 7
3 columns

column 1 = a £0.00

Column 2 = enter a letter - excel recognises the letter and transfers to column 3

Column 3 = £0.00 if letter in column 2 entered

See More: help with excle formula

Report •

December 9, 2014 at 07:47:23
What are you asking???? if you need help you need to be a bit more proactive and give a lot more detail, otherwise we have no idea what you are asking and what problem you are facing.

Report •

December 9, 2014 at 07:57:16
Sorry, I don't understand what it is your trying to accomplish.

You want cell A1 to contain the letter A and an Amount?

Then in cell B1 when a user enters a letter, transfer the letter to cell C1.
By "transfer" do you mean copy, so that the letter is in both B1 & C1?
Also, you say: excel recognizes the letter
How is Excel going to recognize the letter? Do you have a list of some sort?

Then in cell C1 enter an Amount. If you do that, then you will overwrite
the letter you just entered in the above.

Try posting a small sample of your spreadsheet
make sure to include Column Letters and Row Numbers
also read this HOW-TO which explains the use of the < PRE > tags
to align your data.

Give a before and after sample.


message edited by mmcconaghy

Report •
Related Solutions

Ask Question