# How to Convert Negative Numbers to Zero in Google Sheets

To convert negative numbers to zero in Google Sheets, you can use the `MAX`

function. The `MAX`

function returns the maximum value between a set of numbers. By using the `MAX`

function with 0 and the cell reference, you can ensure that the result will always be zero or a positive number.

Here's how to use the `MAX`

function to convert negative numbers to zero:

- Open your Google Sheets document.
- Click on the cell where you want the converted value to appear.
- Type the formula
`=MAX(0, A1)`

in the cell, where`A1`

is the cell reference containing the number you want to convert. Replace`A1`

with the appropriate cell reference in your sheet. - Press Enter to apply the formula.
- If you want to apply this formula to other cells, click on the cell containing the formula, and the bottom-right corner will have a small blue square. Click and drag this blue square to the range of cells where you want the formula to be applied.

## Example

Let's say you have the following data in column A:

```
A
1 -5
2 10
3 -3
4 7
5 -8
```

To convert the negative numbers to zero, follow these steps:

- Click on cell B1.
- Type the formula
`=MAX(0, A1)`

in cell B1. - Press Enter.
- Click on cell B1 again, and then click and drag the blue square in the bottom-right corner of the cell down to B5.

The result will be:

```
B
1 0
2 10
3 0
4 7
5 0
```

All negative numbers in column A have been converted to zero in column B.

Did you find this useful?