How to make a formula display results only if value is greater tha

S

superfooz74

I am new to Excel formulas. I assume i need an IF statement but not sure on
correct syntax
=D2-B2 is what i have now, what can i add to it so that it only displays
values >0?
 
H

Harald Staff

That depends on what you want to happen in the cell if D2 < B2.

Contain 0:
=MAX(D2-B2,0)

Contain empty string:
=IF(D2>B2,D2-B2,"")

Contain negative number but hide it from view:
Menu Format > Conditional formatting, criteria: value < 0 format: text color
same as background color.

Contain negative number but display zero:
Format > Cells > Number > Custom number format 0;"0"
(or maybe it's a comma instead of a semicolon)

HTH. Best wishes Harald
 
Top