| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need linked cell to be blank not 0
I am trying to link sheets, if the data in the reference cell in sheet 1 is
blank I would like the corresponding cell in sheet 2 to be blank, currently it shows zero (0). How di I make it blank? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need linked cell to be blank not 0
One way:
If you're referencing A1 from Sheet 1, use =IF(Sheet1!A1<"",Sheet1!A1,"") instead of =Sheet1!A1. If you don't care about the values: Tools-Options-View uncheck Zero Values. "amquintero" wrote: I am trying to link sheets, if the data in the reference cell in sheet 1 is blank I would like the corresponding cell in sheet 2 to be blank, currently it shows zero (0). How di I make it blank? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need linked cell to be blank not 0
That worked perfectly. Thank you so much!
"sb1920alk" wrote: One way: If you're referencing A1 from Sheet 1, use =IF(Sheet1!A1<"",Sheet1!A1,"") instead of =Sheet1!A1. If you don't care about the values: Tools-Options-View uncheck Zero Values. "amquintero" wrote: I am trying to link sheets, if the data in the reference cell in sheet 1 is blank I would like the corresponding cell in sheet 2 to be blank, currently it shows zero (0). How di I make it blank? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a blank cell instead of a zero value for two linked sheets. | Excel Discussion (Misc queries) | |||
| Results from blank linked cells | New Users to Excel | |||
| do not chart cells linked from worksheets that are blank | Charts and Charting in Excel | |||
| Why does linked data from blank cells become a zero? | Excel Discussion (Misc queries) | |||
| How to keep linked cells blank until information is entered? | Excel Worksheet Functions | |||
Linear Mode
