Change positive numbers to negative in Excel and Google Sheets
=IF(A2>0,-A2,A2)
Embedded Files
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
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
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
Other useful Google and Excel functions to change the number sign
- Change the negative number to zero
- Change negative to positive numbers
- Remove negative sign from numbers
- Calculate percentage changes for containing zero or negative values
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria
Google Sites
Report abuse