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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top