Table Formula

F

Frank

In an Invoice template...
How can I calculate Qty (column a) * Unit Price (column c) = $amount (column
d) in each of several rows.
Then, at the bottom insert a formula to subtotal the $amount column.
Then, multiply the subtotal by .07 (sales tax) and put that in the next cell
under.
Then, add the sales tax and subtotal.

Sure this very basic but I've spent all morning trying to no avail.
 
S

Suzanne S. Barnhill

Have you looked at these Help topics?

Field codes: = (Formula) field

Perform calculations in a table

Referencing cells in a table
 
F

Frank

Yes.
Also, how does one delete a formula that is incorrect?
--
Thanks,
Frank


Suzanne S. Barnhill said:
Have you looked at these Help topics?

Field codes: = (Formula) field

Perform calculations in a table

Referencing cells in a table
 
Top