Empty Cell Question.

  • Thread starter Thread starter Bo
  • Start date Start date
B

Bo

I know this is proably a very simple thing.
I'm kinda new to excel so here goes.

I have a cell on sheet 3 of a notebook that I want to
read a certain cell on sheet 1
Reading is no problem. It's just when the source cell (Sheet 1)
is empty I get a 0 value in the cell on sheet 3.
I'd like to have the Cell on sheet 3 blank if the cell on sheet 1 is blank.

TIA!

Bo
 
Bo,

Use a formula like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Offset from an Application.Goto cell = Date or Time 10
VBA set thick borders around non empty cells in range 0
Create if partial match then copy and paste data from one cell to another 1
Progressive number in different sheets 7
hyperlinking to charts in file 1
Runtime error 1004 when trying to insert formula in cells 11
Run two macros for two different sheets 11
Clean this select case code up a bit. 2

Back
Top