To display errors as blank cells, leave the box empty.ĭisplay a certain value in place of an empty cell On the Display tab, do one or more of the following:ĭisplay a certain value in place of an error codeĬheck the Error values as box, and then in the field, type the value that you want to display instead of an error code. On the PivotTable tab, under Data, click Options. The formula in cell A3 returns a zero (0) value, and Excel displays the value located between the quotation marks in the then argument (also called the value_if_true argument). Under Arguments, click the box next to then and do one of the following:Ĭlick the box next to else and type A3, then press the Enter key. Under Arguments, click the box next to value2 and type 0. Under Arguments, click the word True next to is, and then on the pop-up menu, click = (Equal To). Under Arguments, click the box next to value1 and type A3. In the Formula Builder list, double-click IF. On the Formulas tab, in Function, click Formula Builder. In cell A3, type =A1-A2, and then press RETURN.

On a blank sheet, in cell A1 and cell A2, type 10.

To learn more, see the IF function article. You can use the IF function to specify a condition that displays a zero (0) value as a blank cell or as a dash (-) in a cell.