Referencing Blank Cells Without Zeros

[Tarissa]

I would like to reference a blank cell in Sheet1 and have it stay a blank cell in Sheet2 without a 0 popping up. Is there a way to do that?

 

[Aladin Akyurek]

I would like to reference a blank cell in Sheet1 and have it stay a blank cell in Sheet2 without a 0 popping up. Is there a way to do that?

Try...

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

 

[Tarissa]

That works perfectly. Thank you so much!!!

 

[Tarissa]

I want to ask something else, but it's along the same lines so I'm just adding it here.

I'd now like a cell that is currently showing the sum of other cells to be blank unless the value is greater than 0. Is this possible and how do I do it?

 

[jeffreybrown]

Hi Tarissa,

You could use...

=IF(SUM(A1:A3)>0,SUM(A1:A3),"")

 

[taigovinda]

You can also achieve this with custom formatting, without modifying the formula (or the values) for your cell. It just modifies the way it displays. Custom format could be like this (Format->Cells->Number->Custom):

[<0]"";[=0]"";General

Excel Workbook
	A
1	1
2
3
Sheet1

Cell Formulas
Range	Formula
A1	=1
A2	=0
A3	=-1

 

[Tarissa]

Thank you both!