show empty cell when result is 0
 

I want cells to show nothing (empty) when the result is zero. It only should
display result when there are actual values (more than zero)

show empty cell when result is 0
 

Try

=if(myformula0,myyformula,"")

Mike

"willemeulen" wrote:

I want cells to show nothing (empty) when the result is zero. It only should
display result when there are actual values (more than zero)

show empty cell when result is 0
 

"willemeulen" wrote:
I want cells to show nothing (empty) when the result is zero. It only
should display result when there are actual values (more than zero)

Do want the cell only to __appear__ blank, or do you want the cell value to
actually __be__ blank?

If the former, then try the custom format "General;-General;" without
quotes. Note the last semicolon followed by nothing. You can replace
"General" with any other number format that you want.