make cell report zero if it's a negative number

B

Bob

If my formula in an Excel cell reports a negative number, for the sake of
adding up values in a column (SUM) how do I get that cell to just report zero
value?
 
D

David Biddulph

=(MAX,0,your_formula)
Or change you SUM to SUMIF, with a condition of greater than 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Newbie Help - IF Yes No Function 0
Excel does not accept text format! 0
Dividing - Negative Number by Zero 5
Autonumber field in Excel that behaves the same as Access 0
Custom Number Format for text 13
if cell is blank 8
Returning zero if the results of a formula is a negative number? 7

Top