professor-excel.com
Return Blank Cells Instead of Zeroes in Excel Formulas
If linked cells in Excel are empty, 0 is returned. For example, cell A1 is blank and you refer to A1, zero is returned. This article introduces 3 simple options how to return blanks instead of 0 in Excel formulas.