Reference shows zero

T

TommyD

Hi,

I have a cell reference in cell B1 (=A1).

If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is?

Both cells have format General.


/Tommy
 
F

Fred Smith

"Why isn't B1 empty if A1 is?" is the same as "Why does the sun rise in the
east?" That's just the way it is.

Modify your formula to:
=if(a1="","",a1)

Regards,
Fred
 
T

T. Valko

An empty cell evaluates as 0.

If you want the formula to reurn a blank when A1 is empty...

=IF(A1="","",A1)

Or, *if* the value to be returned is TEXT:

=T(A1)
 
T

TommyD

Thanks for your answer… but the strange thing is that I have an other excel
spreadsheet where this phenomena doesn’t occur so I thought it could have
something to do with settings?

/Tommy
 
G

Gord Dibben

Could be a settings issue.

There is an option to disply or not display zero values.

Might be the other Excel workbook has display zero values unchecked.

In 2003........Tools<Options>View>Window Options.

In 2007........Button>Excel Options>Advanced>Display options for this
worksheet.


Gord Dibben MS Excel MVP
 
Top