Excel formula for an "if" "then" scenario linking 3 worksheets

J

John

I am working with 3 worksheets in the same workbook. My worksheet tabs are
labeled: 9C moinfo slsbudg

I am trying to create a formula in the cell for worksheet tab 9C that links
the two other worksheets. In words this is what I need the formula to do:

If moinfo cell F5 = 1, then slsbudg cell C32=9C cell F19

Any help is greatly appreciated.
Thanks!
 
E

Eduardo

Hi,
Not clear what you want could you be a little more specific in your example,
thanks
 
F

Fred Smith

In slsbudg!C32: =if(moinfo!f5=1,9C!F19,"")

The easiest way to get these formulas is let Excel do it. Go to the cell
where you want the result (ie, C32 in slsbudg).
Enter: =if(
Now navigate to your F5 cell in moinfo [you will see Excel creating the
formula for you]
Enter: =1,
Navigate to your F19 cell in 9C
Enter: ,"")
Hit the return key.

Once you learn this feature you will never type a cell address again.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top