Referencing a cell (from another worksheet) in a formula

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
 
A

Aladin Akyurek

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
Click to expand...
creating financial statements
 
O

Ozzie

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


------------------------------------------------
[/url]
~~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
 
Top