Changing blank cell values to 0

1

I have a data set that contains some black cells. How do I write a formula to change the black cells to a 0 value so I can calculate a column?

09
Screen Shot 2018-10-04 at 10.38.09.png242×1100 7.13 KB

2

You would need to create another column with the calculated items, then do something like this:

=if(CVR2.isBlank(), 0, CVR2)

If this CVR2 is already a calculation column, you could put the If statement right into the CVR2 column to return 0 for blanks, and if not blank then do the calculation you already have on it.

Good luck.

1 Like
3

Awesome!.
Thank you for this.

Cheers,
Sean.

4

Another small hack: if you set the default value for the column to 0, it will fill in all the empty cells with the default value. If you don’t want that, you can hit undo once.

1 Like