How do I multiply in my formula? I followed instructions & keep g.

  • Thread starter busytranscriptionist
  • Start date
B

busytranscriptionist

Unable to get correct formula for my invoice

DOS LINES RATE AMOUNT
02-02-05 200 x @0.12 $
24.00
02-05-05 1056 x @0.12 $
126.72

Total =
$ 150.72
My formula should be # of lines multiplied by @0.12 = AMOUNT and then I
want my formula to continue to summate all the way down to total - to
calculate across and down both. Help please! I keep following the
instructions and keeping getting the incorrect amount.
 
S

Suzanne S. Barnhill

Assuming that the table is as you've showed it, then row 1 is your heading
row, row 2 is the first detail row, and so on. Your columns are A (DOS), B
(LINES), C (RATE), and D (AMOUNT). In cell D2, your formula would be { = B2
* 0.12 }. In cell D3, it would be { = B3 * 0.12 }. Etc. Your total, provided
there are no empty cells, can be { = SUM(ABOVE) }.
 
S

Suzanne S. Barnhill

Forgot to add, that if you want decimal places on each result, you'll need
to add a numeric picture switch, such as \# 0.00. For more on that, see
Word's Help topic "Numeric Picture (\#) field switch."
 

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