|
This still may be too simple an answer.
Say you have a cell that's computed:
=sum(a1:b4)
Now you want it to only display computed values greater than zero:
=if(sum(a1:b4) > 0;sum(a1:b4);0)
Replace the final zero with "" to display a blank cell instead of zero.
There are other methods but that's the classic double calculation used since Visicalc.
|