leave cell blank if negative or zero

Thanks very much for your replies.

While doing some more searching I found a suggestion to someone else's similar question; add a '<' before the '=' . So the new formula would look like this:

 IF(W4-W3<=0,"",W4-W3)

Seems to work on the spreadsheet I'm working on.  Haven't tried it on any other spreadsheets though. If anyone knows of a problem with doing a formula this way, please let me know.

Thanks again

fritzmom

Hello,

there are two possible approaches to this: formula or formatting.

A formula like this will work: =IF(COUNT(W3:W4)=2,W4-W3,"")

Or with formatting, just use the formula =W4-W3 and format it with custom format

0;;;

Replace the 0 with 0.00 or any other number format you prefer. The formatting approach will hide all negative and zero values. If your data can produce negative values as the result of the formula, the formula approach may be better.

fritzmom wrote:

=IF(W4-W3=0,"",W4-W3)   this would leave either a positive value or a blank in cell X4 

However, if there is NO value yet inputted in cell W5, then cell X5 will show as a negative value.

What would the formula be for cells X5 : X15  so that I don't see either the negative or a zero.

Perhaps one of the following:

=IF(OR(W4="",W3=""),"",W4-W3)

or

=IF(COUNT(W3,W4)<2,"",W4-W3)

Hi,

Try this

=MAX(J3-K3;0)

Hello,

replace the commas with semicolons. In most European countries, the computers are set up to use a semicolon between formula parameters.

=if(J3-K3<=0;"";J3-K3)

Watch what happens when you start typing a formula into a cell. Type

=IF( 

and take note of the symbols used in the tooltip.