Question: how do you make a formula negative in excel?
Answer: Highlight the range that you want to change, then right-click and choose Paste Special from the context menu to open the Paste Special dialog box. ... 
Then select All option from the Paste, and Multiply from the Operation.