Possitive Formulas

[Judi]

Can you make a cell just have a possitive formula?
For instance if Cell B3 is $40.00 and cell B4 is $60.00
and I want cell B5 to be B3-B4...this would be a negative
number for cell B5. Is there a to formulate that B5 will
only post if it is a possitive number? Thank you for any
help you can offer.

 

[Bernard V Liengme]

If you want an answer only if it is positive: =IF(B3-B4>0,B3-B4," ")
If you want an answer every time but you want it to be positive =ABS(B3-B4)
Bernard

 

[Laura Cook]

=IF((B3-B4)<0,"",B3-B4)