Referencing a cell (from another worksheet) in a formula

[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

 

[Aladin Akyurek]

Let F10 be on Sheet1 and D5 on Sheet2...

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

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

creating financial statements

 

[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

guide to creating financial statements

 

[JAM]

Awesome! Thanks.