Reference shows zero

[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

 

[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. 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)

 

[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

 

[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

 

[TommyD]

Thanks, that's solved it!

/Tommy

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




.