Excel Formulas
 

While printing a excel sheet I do not want cells containing formulas printing
zeroes or any other characters like error values, it should print just empty.

Excel Formulas
 

Change your formulas so they return "" instead of zeros or error values.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Aravind"
wrote in message
While printing a excel sheet I do not want cells containing formulas printing
zeroes or any other characters like error values, it should print just empty.

Excel Formulas
 

Jim Cone" wrote in message
...
Change your formulas so they return "" instead of zeros or error values

Wasn't the OP asking how you it is that you do that?

To the OP:

If =G2+H2 is returning 0 when both cells are empty then use:

=IF(AND(G2="",H2=""),"",G2+H2)

If it could return an error value then you could use:

=IF(OR(ISERROR(G2+H2),AND(G2="",H2="")),"",G2+H2)

However, if it was returning that error because one of the cells had text in
it, the the second formula would hide that fact. It would be much better to
deal with the source of the error rather than simply hide it.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Excel Formulas
 

"Sandy Mann" wrote...
....
=IF(OR(ISERROR(G2+H2),AND(G2="",H2="")),"",G2+H 2)

Or use one test.

=IF(COUNT(1/(G2+H2)),G2+H2,"")

However, if it was returning that error because one of the cells had text in
it, the the second formula would hide that fact. It would be much better to
deal with the source of the error rather than simply hide it.

Very true.

Excel Formulas
 

Thanks Jim for your immediate response. But I found another way.
Go to ToolsOptionsViewZero Values and untick the box.

But I don't know if it works when the cell shows error values

"Jim Cone" wrote:


Change your formulas so they return "" instead of zeros or error values.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Aravind"
wrote in message
While printing a excel sheet I do not want cells containing formulas printing
zeroes or any other characters like error values, it should print just empty.