To leave a blank cell
 

Hello from Steved

With the below formula what is required please to have the cell blank as at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.

To leave a blank cell
 

something like:
=If(Yourformula=0,"",Yourformula)
Note that there is NO space between the two quote marks. In other words, it
is "", not " ". HTH Otto
"Steved" wrote in message
...
Hello from Steved

With the below formula what is required please to have the cell blank as
at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.

To leave a blank cell
 

Hi Steved,

How about Tools/options/view, and deselect "zero values" ?

"Steved" wrote:

Hello from Steved

With the below formula what is required please to have the cell blank as at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.

To leave a blank cell
 

Do you mean ...?

=IF('City Depot'!C9+'Panmure Depot'!C9=0,"",'City Depot'!C9+'Panmure
Depot'!C9)

HTH

"Steved" wrote:

Hello from Steved

With the below formula what is required please to have the cell blank as at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.

To leave a blank cell
 

Have you tried conditional formatting? (Menu: Format - Conditional
Formatting)
Set up the cell so that values less than zero have white type.
Jill


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=562199

To leave a blank cell
 

I thankyou all

"Steved" wrote:

Hello from Steved

With the below formula what is required please to have the cell blank as at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.

To leave a blank cell
 

You could also give the cell's number format a custom format like:

#;-#;

(replace the # and -# with your desired format for positive and negative
numbers)

HTH,
Ryan

"Steved" wrote:

Hello from Steved

With the below formula what is required please to have the cell blank as at
the moment it shows 0.

ps I do not want to turn zero off

='City Depot'!C9+'Panmure Depot'!C9

Thankyou.