Question: how to calculate negative number on excel?
Answer: Select the cell or range of cells that you want to format with a negative number style.
If you're using Windows, press Ctrl+1. ... 
In the Category box, click either Number or Currency.