Creating a function that makes a negative number a zero

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

Guest

I am trying to create a function that will subtract, but if the answer is
less than zero, will put a zero in the cell. I don't know how to do this.
Can you help me?
 
Hi
You could try wrapping your formula in a MAX function:
=MAX(yourfunction,0)
 
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

Returning Zero 10
IF function 1
negative numbers as a zero 5
Formatting negative numbers to equal zero 3
Negative Zero? 3
Greater Than Symbols and calculations 0
Format cells to make zeros not appear,or be invisible on screen &p 3
Replacing negative formual results with a zero. 2

Back
Top