give me a formula to prevent negative numbers when subtracting result is less than zero
give me a formula to prevent negative numbers when subtracting result is less than zero
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)