show empty cell when result is 0

[willemeulen]

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)

 

[Mike H]

Try

=if(myformula>0,myyformula,"")

Mike

 

[JoeU2004]

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.