Excel- If formula equals 0 or less, how do I show nothing? 2

[rickes]

If the formula in a cell returns a value of a negative number, how do i make the condition in that cell show no number at all? I want the cell to be blank util the condition shows a positive number from the formula.

 

[SkipVought]

Hi,
[tt]
=If(expression=0,"",expression)
[/tt]


Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[orman]

You can use this formula. Subsitute "A1" with your formula.
=IF(A1<=0,"",A1)

 

[straybullet]

Or you could format the cell as follows:
Choose the Custom category. In the Type box, put 0;;.
This will allow neither a negative nor a zero from showing in that cell.

Let them hate - so long as they fear... Lucius Accius