Re: Empty Cell Question.

From: Bo (bo_at_columbus.rr.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 18:37:06 GMT

THANK YOU!!!!

"Chip Pearson" <chip@cpearson.com> wrote in message
news:uQi9yy99DHA.1948@TK2MSFTNGP12.phx.gbl...
> Bo,
>
> Use a formula like
>
> =IF(Sheet1!A1="","",Sheet1!A1)
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Bo" <bo@columbus.rr.com> wrote in message
> news:M%rZb.115$Ze2.99@fe1.columbus.rr.com...
> > I know this is proably a very simple thing.
> > I'm kinda new to excel so here goes.
> >
> > I have a cell on *** 3 of a notebook that I want to
> > read a certain cell on *** 1
> > Reading is no problem. It's just when the source cell (*** 1)
> > is empty I get a 0 value in the cell on *** 3.
> > I'd like to have the Cell on *** 3 blank if the cell on ***
> 1 is blank.
> >
> > TIA!
> >
> > Bo
> >
> >
> >
>
>