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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |