Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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