The same math addition and subtraction operators (+, -) that you learned in elementary school are used to build formulas in WordPerfect tables. Use the Calculate dialog box to update calculations in your table, or to turn on the automatic calculation (recommended). Or, choose Table > Calculate > Calc Table. When you are ready to manually calculate the table, right-click in the table and choose Calculate.Choose Off in the Automatic calculation section.
WordPerfect displays the Calculate dialog box (see Figure 1). To turn off the automatic recalculate, choose Table > Calculate.When this happens, you can turn off the "automatic recalculate" and then calculate manually when you are finished editing. In a large table, the recalculating process can slow down the operation of your system. You may notice that as you edit numbers in cells that are included in a QuickSum, the total is automatically updated while you work. The workaround is to make sure you have numbers in all the cells, even if some of the numbers are zero. If a cell is empty, QuickSum doesn't calculate any cell above the empty one. The little blue triangle that appears in the lower right corner indicates that a cell has a formula in it.Ī QuickSum formula in a column adds all the numbers in cells directly above it a QuickSum at the end of a row adds all the numbers to the left of it. Press Ctrl + =, or choose Table ? QuickSum. To use QuickSum, click in the cell where you want the total to appear. The QuickSum feature adds the values in all the cells above the formula in a column, or, in all the cells to the left of the formula in a row. Using QuickSumĪdding a column or row of figures is such a common task, there is a shortcut for it. And finally, I'll explain how to import information in a Quattro Pro (or Microsoft® Excel) spreadsheet into a WordPerfect table. After that, you'll learn how to create formulas using one of the 500 built-in spreadsheet functions. Next, we'll talk about how to create formulas that calculate a value (rather than typing it in). I'll start with a simple formula that totals a column (or row) of numbers. In this tutorial, I'll show you how to create formulas in tables. What you may not yet realize is that you can create formulas in WordPerfect tables and do some pretty fancy calculations on those numbers.Īnd if you can do calculations in WordPerfect tables, why turn to another program for simple tasks such as adding a series of numbers? Many users find that they construct small spreadsheets in WordPerfect and turn to Quattro Pro® for larger, more complex spreadsheets. You can use tables in a variety of situations, but most of us turn to them when we need to position text and numbers in columns. Creating Formulas in a Table by Laura AcklenĪs you may already know, the Table feature is one of the most powerful features in WordPerfect®.
0 kommentar(er)
