# 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 — 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 — 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