function for conditional value from another worksheet
 

I'm trying to say if the value in a cell in worksheet A is blank, let the
value in worksheet B also be blank. (Cells are linked)

If the value in a that cell in worksheet A is anything other than blank,
show it in worksheet B.

The linked cells are text, dates, numbers, etc.

Help me!

function for conditional value from another worksheet
 

You can use a If in the formula

=IF(Sheet1!A1="","",Sheet1!A1)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"frustrateddotcom" wrote in message
...
I'm trying to say if the value in a cell in worksheet A is blank, let the
value in worksheet B also be blank. (Cells are linked)

If the value in a that cell in worksheet A is anything other than blank,
show it in worksheet B.

The linked cells are text, dates, numbers, etc.

Help me!

function for conditional value from another worksheet
 

Instead of : =Sheet1!A1
use: =IF(Sheet1!A1="","",Sheet1!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"frustrateddotcom" wrote:
I'm trying to say if the value in a cell in worksheet A is blank, let the
value in worksheet B also be blank. (Cells are linked)

If the value in a that cell in worksheet A is anything other than blank,
show it in worksheet B.

The linked cells are text, dates, numbers, etc.

Help me!

function for conditional value from another worksheet
 

Thank you very much. It worked!

"Max" wrote:

Instead of : =Sheet1!A1
use: =IF(Sheet1!A1="","",Sheet1!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"frustrateddotcom" wrote:
I'm trying to say if the value in a cell in worksheet A is blank, let the
value in worksheet B also be blank. (Cells are linked)

If the value in a that cell in worksheet A is anything other than blank,
show it in worksheet B.

The linked cells are text, dates, numbers, etc.

Help me!

function for conditional value from another worksheet
 

Thank you very much. It worked!

"Ron de Bruin" wrote:

You can use a If in the formula

=IF(Sheet1!A1="","",Sheet1!A1)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"frustrateddotcom" wrote in message
...
I'm trying to say if the value in a cell in worksheet A is blank, let the
value in worksheet B also be blank. (Cells are linked)

If the value in a that cell in worksheet A is anything other than blank,
show it in worksheet B.

The linked cells are text, dates, numbers, etc.

Help me!

function for conditional value from another worksheet
 

"frustrateddotcom" wrote:
Thank you very much. It worked!

Marvellous to hear that !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---