Change positive numbers to negative in Excel and Google Sheets

=IF(A2>0,-A2,A2)

A2 = positive number cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Change positive numbers to negative in Excel

How to change positive to negative numbers in Excel?
Change positive numbers to negative in Excel

 CHANGE POSITIVE NUMBERS TO NEGATIVE — EXCEL FORMULA AND EXAMPLE

=IF(A2>0,-A2,A2)

The condition is to find if the cell is less than zero and if TRUE changes to negative and keep the same value if the cell has negative data.

💡 If you want to change the 0 value as well to a negative value, change the condition from >0 to >=0 

Change positive numbers to negative in Google Sheets

How to change positive to negative numbers in Google Sheets?
Change positive numbers to negative in Google Sheets

CHANGE POSITIVE NUMBERS TO NEGATIVE — GOOGLE SHEETS FORMULA AND EXAMPLE

=IF(A2>0,-A2,A2)

The condition is to find if the cell is less than zero and if TRUE changes to negative and keep the same value if the cell has negative data.

💡 If you want to change the 0 value as well to a negative value, change the condition from >0 to >=0