Reference shows zero
 

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

Reference shows zero
 

"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

"TommyD" wrote in message
...
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

Reference shows zero
 

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)

--
Biff
Microsoft Excel MVP


"TommyD" wrote in message
...
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

Reference shows zero
 

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

/Tommy

"Fred Smith" wrote:

"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

"TommyD" wrote in message
...
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


.

Reference shows zero
 

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<OptionsViewWindow Options.

In 2007........ButtonExcel OptionsAdvancedDisplay options for this
worksheet.


Gord Dibben MS Excel MVP


On Wed, 3 Feb 2010 12:07:01 -0800, TommyD
wrote:

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

"Fred Smith" wrote:

"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

"TommyD" wrote in message
...
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


.

Reference shows zero
 

Thanks, that's solved it!

/Tommy

"Gord Dibben" wrote:

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<OptionsViewWindow Options.

In 2007........ButtonExcel OptionsAdvancedDisplay options for this
worksheet.


Gord Dibben MS Excel MVP


On Wed, 3 Feb 2010 12:07:01 -0800, TommyD
wrote:

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

/Tommy

"Fred Smith" wrote:

"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

"TommyD" wrote in message
...
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


.


.