98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » One cell to equal content of a choice of cells | Excel forum
One cell to equal content of a choice of cells | Excel forum
Resolved · High Priority · Version 2003
Angela has attended:
Excel VBA Intro Intermediate course
One cell to equal content of a choice of cells
Hi
How do I make a cell equal the input of a choice of cells depending on which one is populated.
e.g currently I have the formula in F14 which read =F7 ,to make it equal the contents of F7 but I want amend this to equal either F7,F8 or F9?
Many thanks
Angela
RE: One cell to equal content of a choice of cells
Hi Angela
Thank you for your question.
What criteria choses which value from F7, F8 or F9 goes into cell F14? You'll need that to work out the formula for F14.
Laura GB
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |