2011
Table Of Contents
- Contents
- Get Information
- The User Interface
- Start and Save Drawings
- Control the Drawing Views
- Organize Drawings and Layouts
- Create and Modify Objects
- Control the Properties of Objects
- Use Precision Tools
- Use Coordinates and Coordinate Systems (UCS)
- Use Dynamic Input
- Snap to Locations on Objects (Object Snaps)
- Restrict Cursor Movement
- Combine or Offset Points and Coordinates
- Specify Distances
- Extract Geometric Information from Objects
- Use a Calculator
- Draw Geometric Objects
- Change Existing Objects
- Select Objects
- Correct Mistakes
- Erase Objects
- Cut, Copy, and Paste with the Clipboard
- Modify Objects
- Modify Complex Objects
- Add Constraints to Geometry
- Define and Reference Blocks
- Work with 3D Models
- Create 3D Models
- Overview of 3D Modeling
- Create Solids and Surfaces from Lines and Curves
- Create Solids
- Create Surfaces
- Create Meshes
- Create Wireframe Models
- Add 3D Thickness to Objects
- Modify 3D Models
- Create Sections and 2D Drawings from 3D Models
- Create 3D Models
- Annotate Drawings
- Work with Annotations
- Hatches, Fills, and Wipeouts
- Notes and Labels
- Tables
- Dimensions and Tolerances
- Understand Basic Concepts of Dimensioning
- Use Dimension Styles
- Set the Scale for Dimensions
- Create Dimensions
- Modify Existing Dimensions
- Add Geometric Tolerances
- Plot and Publish Drawings
- Specify Settings for Plotting
- Save Plot Settings as Named Page Setups
- Reuse Named Page Setups
- Specify Page Setup Settings
- Select a Printer or Plotter for a Layout
- Select a Paper Size for a Layout
- Determine the Drawing Orientation of a Layout
- Set the Plot Area of a Layout
- Adjust the Plot Offset of a Layout
- Set the Plot Scale for a Layout
- Set the Lineweight Scale for a Layout
- Select a Plot Style Table for a Layout
- Set Shaded Viewport and Plot Options for a Layout
- Print or Plot Drawings
- Overview of Plotting
- Use a Page Setup to Specify Plot Settings
- Select a Printer or Plotter
- Specify the Area to Plot
- Set Paper Size
- Position the Drawing on the Paper
- Control How Objects Are Plotted
- Preview a Plot
- Plot Files to Other Formats
- Specify Settings for Plotting
- Share Data Between Files
- Reference Other Drawing Files
- Work with Data in Other Formats
- Collaborate with Others
- Render Drawings
- Draw 2D Isometric Views
- Add Lighting to Your Model
- Materials and Textures
- Render 3D Objects for Realism
- Glossary
- Index
Use Formulas in Table Cells
Table cells can contain formulas that do calculations using the values in other
table cells.
With a table cell selected, you can insert formulas from the Table Cell visor.
You can also open the In-Place Text Editor and enter a formula in a table cell
manually.
Insert a Formula
In formulas, cells are referred to by their column letter and row number. For
example, the cell at top left in the table is A1. Merged cells use the number
of what would be the top-left cell. A range of cells is defined by the first and
last cells, with a colon between them. For example, the range A5:C10 includes
cells in rows 5 through 10 in columns A, B, and C.
A formula must start with an equal sign (=). The formulas for sum, average,
and count ignore empty cells and cells that do not resolve to a numeric value.
Other formulas display an error (#) if any cell in the arithmetic expression is
empty or contains nonnumeric data.
Use the Cell option to select a cell in another table in the same drawing. When
you have selected the cell, the In-Place Text Editor opens so you can enter the
rest of the formula.
Copy a Formula
When you copy a formula to another cell in the table, the range changes to
reflect the new location. For example, if the formula in A10 sums A1 through
A9, when you copy it to B10, the range of cells changes so that it sums B1
through B9.
If you don't want a cell address to change when you copy and paste the
formula, add a dollar sign ($) to the column or row part of the address. For
example, if you enter $A10, the column stays the same and the row changes.
If you enter $A$10, both column and row stay the same.
Insert Data Automatically
You can automatically increment data in adjacent cells within a table by using
the AutoFill grip. For example, a table with a date column can have the dates
automatically entered by entering the first necessary date and dragging the
AutoFill grip.
Numbers will fill automatically by increments of 1 if one cell is selected and
dragged. Similarly, dates will resolve by increments of one day if only one cell
764 | Chapter 28 Tables