If anyone happens to know the answer to this, I’d really appreciate the help. I’ve been working on some calculations lately and I've run into a bit of a snag... everything works perfectly fine once I actually plug in my formulas, but whenever a cell is empty, it just displays 0.00. That part is totally fine, but I was wondering if there's a way to make sure those empty rows don't get factored into the math, or even better, how I can just hide those pesky 0.00 values when a row hasn't been filled out yet? Thanks so much in advance!
2 * 3 = 6
- * _ = 0.00
So, basically, does anyone know how to get rid of those zeros when there isn't any actual data to calculate...
2 * 3 = 6
- * _ = 0.00
So, basically, does anyone know how to get rid of those zeros when there isn't any actual data to calculate...