When working in Excel, it may be required to set negative values to zero. For example, if you are trying to determine how much positive income you generated over a particular period of time, you would want to avoid negative figures.
This can be easily achieved using the MAX Function.
Let’s review the example below.
Looking at the below equation, we use the MAX Function and set number1 to Zero. What this does is negates any value that is no Zero or greater. Additionally, it returns a result of Zero.
=MAX (number1,[number2]), ...) =MAX(0,A2-B2)
Ok, let’s set the negative values to zero!
In the sales example below, it shows how this formula can be used to capture the postive sales only between two quarters of data.