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

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!

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

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

"John" wrote:

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!

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

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

"John" wrote in message
...
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!