one cell equal content

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

Excel tip:

Purchase excel

Buy MS Excel on Amazon.com

View all Excel hints and tips


Server loaded in 0.08 secs.