How to Calculate Negatives in Excel. Microsoft Excel has the ability to automatically recognize a positive or negative number that you enter in a cell. However, if an incorrect format is selected ...

If, for example, you wanted to calculate your returns after taxes, you could input the amount of taxes due in the table as a negative number to recalculate an after-tax return.