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 in Excel

CHANGE NEGATIVE NUMBER TO ZERO — EXCEL FORMULA AND EXAMPLE

=IF(A2<=0,0,A2)

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 in Google Sheets

CHANGE NEGATIVE NUMBER TO ZERO — GOOGLE SHEETS FORMULA AND EXAMPLE

=IF(A2<=0,0,A2)

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