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