| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make +'sheet 1'A1 not show up as zero
when there is nothing in the cell A1 on sheet 1, how can i make sheet 2 leave
a blank cell also instead of inserting a "0"? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make +'sheet 1'A1 not show up as zero
=IF('sheet 1'!A1="","",'sheet 1'!A1)
"tarabull" wrote: when there is nothing in the cell A1 on sheet 1, how can i make sheet 2 leave a blank cell also instead of inserting a "0"? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make +'sheet 1'A1 not show up as zero
this now makes my file huge - is there any was to do it as to keep it smaller?
"RonaldoOneNil" wrote: =IF('sheet 1'!A1="","",'sheet 1'!A1) "tarabull" wrote: when there is nothing in the cell A1 on sheet 1, how can i make sheet 2 leave a blank cell also instead of inserting a "0"? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make +'sheet 1'A1 not show up as zero
How many cells did you place the formula into?
Do you need that many? Gord Dibben MS Excel MVP On Mon, 23 Mar 2009 09:24:01 -0700, tarabull wrote: this now makes my file huge - is there any was to do it as to keep it smaller? "RonaldoOneNil" wrote: =IF('sheet 1'!A1="","",'sheet 1'!A1) "tarabull" wrote: when there is nothing in the cell A1 on sheet 1, how can i make sheet 2 leave a blank cell also instead of inserting a "0"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i make the whole y axis label show up it wont show the end | Charts and Charting in Excel | |||
| How to format sheet to show first box whilst tabbing across sheet | Excel Discussion (Misc queries) | |||
| Excel: have add'l rows entered in sheet 1 always show up in sheet | Excel Worksheet Functions | |||
| Make a cell show the name of the sheet tab | Excel Worksheet Functions | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Linear Mode
