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