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?
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.
Thank you for this.