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.
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.