Referencing a cell (from another worksheet) in a formula

  • Thread starter Thread starter JAM
  • Start date Start date
J

JAM

I am trying to reference a cell (from another workshet) in a formula .
The formula is:
=IF(F10<=3,this is where I want to reference a cell in another
worksheet,"")

So IF cell F10 is <=3 I want the text entered from a cell in another
work sheet. If it is false I want it to be blank.

Can anyone provide me with a little help?

Thanks,
JAM
 
Let F10 be on Sheet1 and D5 on Sheet2...

=IF(F10<=3,Sheet2!D5,"")

JAM said:
I am trying to reference a cell (from another workshet) in a formula .
The formula is:
=IF(F10<=3,this is where I want to reference a cell in another
worksheet,"")

So IF cell F10 is <=3 I want the text entered from a cell in another
work sheet. If it is false I want it to be blank.

Can anyone provide me with a little help?

Thanks,
JAM


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
open both files. enter your formula, when you get
to "this is where I want to reference a cell in another
worksheet, then click on window, click on the other file
name, then click on the cell, then complete your formula

you could also just type it in, but its easier with a
mouse since the file name and tab are referenced correctly
and automatically.

hope this helps.


-----Original Message-----

I am trying to reference a cell (from another workshet) in a formula .
The formula is:
=IF(F10<=3,this is where I want to reference a cell in another
worksheet,"")

So IF cell F10 is <=3 I want the text entered from a cell in another
work sheet. If it is false I want it to be blank.

Can anyone provide me with a little help?

Thanks,
JAM


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
Back
Top