Forum home » Delegate support and help forum » Microsoft Excel Training and help » One cell to equal content of a choice of cells
|
|
|
The UK's most regular 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. |
One cell to equal content of a choice of cells
Resolved · High Priority · Version 2003
Reply Mon 27 Oct 2008, 11:31Delegate Angela said...
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
For upcoming training course dates see: Pricing & availability
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
|