How to solve a formula so that it returns actual answer if negati.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a formula so that it displays all negative results but
defaults to zero if the answer is any positive number.
 
You must log in or register to reply here.

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

Trying to reconcile a column 1
Returning Zero 10
calculating results in formulas 9
Returning zero if the results of a formula is a negative number? 7
Need Help with a Formula 5
I need a formula 2
replace a negative result with a zero? 2
Only Cells with positive answer to IF formula 3

Back
Top