Change the negative number to zero in Excel and Google Sheets
=IF(A2<=0,0,A2)
A2 = negative number cell
Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.Change the negative number to zero in Excel
How to change the negative number to zero in Excel?Change the negative number to zero in Excel
CHANGE NEGATIVE NUMBER TO ZERO — EXCEL FORMULA AND EXAMPLE
CHANGE NEGATIVE NUMBER TO ZERO — EXCEL FORMULA AND EXAMPLE
=IF(A2<=0,0,A2)
A2<=0 = condition to find if the cell is less than or equal to zero
A2<0 = condition to find negative value
The condition to find if the cell is less than or equal to zero and if TRUE assign the value to 0 if not will get the value of the cell. If you want to keep 0 value and only change negative value change condition from <=0 to <0
Change the negative number to zero in Google Sheets
How to change the negative number to zero in Google Sheets?Change the negative number to zero in Google Sheets
CHANGE NEGATIVE NUMBER TO ZERO — GOOGLE SHEETS FORMULA AND EXAMPLE
CHANGE NEGATIVE NUMBER TO ZERO — GOOGLE SHEETS FORMULA AND EXAMPLE
=IF(A2<=0,0,A2)
A2<=0 = condition to find if the cell is less than or equal to zero
A2<0 = condition to find negative value
The condition to find if the cell is less than or equal to zero and if TRUE assign the value to 0 if not will get the value of the cell. If you want to keep 0 value and only change negative value change condition from <=0 to <0
Other useful Google and Excel functions to change the number sign
- Change negative to positive numbers
- Change positive numbers to negative
- 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
- Change the negative number to zero
- 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