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

"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

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

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


.

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


.

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


.


.