Possitive Formulas

  • Thread starter Thread starter Judi
  • Start date Start date
J

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.
 
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
 
Back
Top