| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link to an empty cell question. | Excel Worksheet Functions | |||
| Reposted question: If cell is empty show userform???????? | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| empty cell question | Excel Worksheet Functions | |||
Hybrid Mode
