formula

0

give me a formula to prevent negative numbers when subtracting result is less than zero

Answer
Discuss

Discussion

Update the question title to be descriptive please.
don (rep: 1297) Oct 29, '17 at 2:14 pm
Add to Discussion

Answers

0

This formula would return the difference between the two values., always positive.

=ABS(10 - 20)

The formula below will return zero instead of a negative result.

=MAX((10-20), 0)
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login