replace a negative result with a zero?

P

Pam2277

I have my formula entered but need it to return a zero if the result is
negative. Any help is greatly appreciated.
 
P

Pete_UK

Well, what is the formula that you are using?

You could try this:

=MAX(your_formula,0)

to replace your_formula.

Hope this helps.

Pete
 

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

Dividing - Negative Number by Zero 5
subtract times with a negative result 1
Replace the minus value 3
Returning zero if the results of a formula is a negative number? 7
Need Help with a Formula 5
Replacing negative formual results with a zero. 2
Make a negative response to if question equal zero 4
Trying to reconcile a column 1

Top