Excel formulas can give you a lot of power. You can customize
virtually anything about the MacNail construction accounting software by using them--provided that you are careful!
NOTE-- In 2000, MacNail was replaced by
Goldenseal construction
accounting software. Goldenseal is an integrated program that
includes general accounting, job costing, payroll and
project billing, plus estimating and other features.
It does not require the Excel spreadsheet program.
To
create a formula:
1. Click in a cell.
2. Type an equal sign (=).
3. Click the mouse on cells to add them to the formula.
(Each mouse-click enters a cell.)
4. Change any mathematical signs necessary.
NOTE: An addition sign will be inserted automatically
unless you already typed in another arithmetical sign.
Page 208 Using Excel
5. To stop building the formula: type TAB, RETURN, ENTER
or an arrow key.
Formulas can be created in other ways. You can also:
*
Use Copy from the EDIT menu, then Paste the formula into
a new cell. All cell addresses will be adjusted, relative
to the copied cell.
*
Use Fill Down or Fill Right to carry similar formulas
through several cells.
*
Cut and then Paste a cell. The original cell references
will be carried along intact. (Note the difference from
Copy).
*
Type in cell addresses directly (for example, =A32+A33).
Learning Excel's formula entering
process takes some practice. It's a very powerful technique, however, and it's well worth
the effort to learn.
|
