Re: Empty Cell Question.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chip Pearson (chip_at_cpearson.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 12:09:33 -0600

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
>
>
>
Quantcast