how to show formulas page in numbers for mac

You can always ask an expert in the Excel Tech Community or get support in the Answers community. To display zeros, clear the Empty cells as check box. To display blank cells, leave the box empty. Select the Empty cells as check box, and then in the box, type the value that you want to display in empty cells.

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). In this tutorial I'm looking at Numbers - Apple's answer to Microsoft Excel. 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. In a recent tutorial I took an introductory look at Pages, Apple's often neglected word processor and tried to show you that despite its fairly basic interface, it is an incredibly powerful piece of software that allows you to create a multitude of different documents. 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.

How to show formulas page in numbers for mac