Set Negative values to Zero

Originally published at: https://excelbuddy.com/set-negative-values-to-zero/

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.…