Hide zero Values

[Manos]

Dear All
i have a worksheet that i made some calculations
but wherever the calculation gives zero value i want not
to appera on the cell, and just leave the cell blank

There is anyway to do that?

Thanks in advance
Manos

 

[Frank Kabel]

Hi
one way:
=IF(your_calculation_formula=0,"",your_calculation_formula)

 

[Norman Harker]

Hi Manos!

You could use:

Tools > Options > View
Remove check from "Zero values"

Or you could use the following as a base for your formulas:

=IF(Yourformula=0,"",Yourformula)

Or you could use Conditional formatting

Format > Conditional formatting
Cell Value
Is equal to
0
Format button
Select text colour the same as your background color.

The selection is a "horses for courses" one.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Jazzer]

Hi Manos,

Easies way is to use cell formatting. Put in target cell(s) a custo
format like #;#;; and the zeros are gone.

Actually I'm not really sure if you should use ; as a list separator
It depends on your regional settings. Maybe that phrase is written lik
#,#,, in your country.

- Asse

 

[Bob Phillips]

Easier still - Tools>Options>View un check Zero Values.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Portuga]

You can use the following formulas:

=IF(ISERROR(cell number/cell number), ,(cell number/cell number))
=IF(ISERROR(cell number/cell number),-,(cell number/cell number))

The first will leave the cell Blank and the second will leave the cel
with a "-" whenever the result of your formula is 0