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

#DIV error 2
BLANK CELL 1
Leave Cell Blank Continuously 1
Logical test in IF statement returning incorrect result 3
result should equal a blank field 2
when setting a cell to equal a blank cell it displays 0 2
Linking sheets how do I display the zeros (0) as blank cells 1
How do I limit formula results to positive only? 4

Top