• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Working with Math and Equati... > Performing Calculations in a Table

Performing Calculations in a Table

To perform a calculation in a table, you use table references, math operators, and special functions to create a field expression for calculating the desired result. Functions are built-in mathematical formulas that perform operations such as Sum and Average.

Specifying Table Cells in a Formula

As you enter a formula in a field in a table, you refer to individual cells or ranges of cells in the table by using column and row coordinates. The columns of a table are lettered A, B, C, and so on; the rows of a table are numbered 1, 2, 3, and so on, just as they are in a spreadsheet. To refer to an individual cell in a table, specify first the column letter, followed by the row number. To refer to the cell in the second column of the third row of a table, for example, you use the coordinates B3.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint