Tilted Forum Project Discussion Community - View Single Post

cyrnel · 02-20-2005, 06:24 PM

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.

02-20-2005, 06:24 PM	#5 (permalink)
cyrnel Adequate Location: In my angry-dome.	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.