If formula result = 0, do not display-leave cell blank

A

ASG

When the result of a formula's calculation is zero (0) I want the cell to
remain blank instead of showing 0. I am using Microsoft office Excel 2007
 
P

Pete_UK

Try something like this:

=IF(your_formula=0,"",your_formula)

Hope this helps.

Pete
 

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

Countdown macro - display settings 2
Word macro that can call cells out of Excel for a find and replace 0
If Not blank - Formula for two cells 0
Keeping cells blank even though formula is input 3
Use & with two formulas 2
Copy addition formula of non-consecutive horizontal cells 2
when setting a cell to equal a blank cell it displays 0 2
Leave Cell Blank Continuously 1

Top