function for conditional value from another worksheet

[frustrateddotcom]

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!

[Ron de Bruin]

You can use a If in the formula

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

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



"frustrateddotcom" <[email protected]> wrote in message
news:[email protected]...
> 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!

[Max]

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!

[frustrateddotcom]

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!

[frustrateddotcom]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

[Max]

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

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