Hide zero Values


M

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
 
F

Frank Kabel

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

Advertisements

N

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.
 
J

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
 
B

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)
 
Ad

Advertisements

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top