|
Empty Cell Question.
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 |
Empty Cell Question.
Bo,
Use a formula like =IF(Sheet1!A1="","",Sheet1!A1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bo" wrote in message ... 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 |
Empty Cell Question.
THANK YOU!!!!
"Chip Pearson" wrote in message ... Bo, Use a formula like =IF(Sheet1!A1="","",Sheet1!A1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Bo" wrote in message ... 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 |
| All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com