Adding Sales Tax to a Invoice

Question

Adding Sales Tax to a Invoice

Folks,

I have an existing Invoice for my small business I had created in Pages '09. It works great, but now I want to add a section where Pages will automatically take the total sale and add 8.9% Sales Tax to it and place that number to be added to the total sale.

Any ideas on how to do this?

I'm willing to share the invoice file so anyone can see where and how I want it done.

Quad 2.66 MP/5gb/4tb/23"/20" - 60gb Video iPod - 15" Duo 2.16 MBP/2gb, Mac OS X (10.5.7), iPhone!

Posted on Aug 3, 2009 8:22 AM

Reply

Answer 1

Badunit

Level 7

30,588 points

Aug 3, 2009 8:24 AM in response to Brien Tomassetti

If it is in a table, you can do formulas in Pages tables.

Reply

Answer 2

Aug 3, 2009 8:38 AM in response to Badunit

Yes, I know. I need to know the Formula. I cannot find it in the Help section.

Reply

Answer 3

Aug 3, 2009 8:45 AM in response to Brien Tomassetti

Brien,

Assuming the sales total to be in Cell A1, the sales tax would be =ROUND(A1*0.089, 2), and the total with sales tax would be =ROUND(A1*1.089, 2), for a sales tax of 8.9%.

Jerry

Reply

Answer 4

KOENIG Yvan

Level 8

41,819 points

Aug 3, 2009 8:48 AM in response to Brien Tomassetti

The formulas are described in :

iWork Formulas and Functions Help

Or better in
iWork Formulas and Functions User Guide.

Assuming that the Total is in C12
in D12 enter:
=ROUND(C*0.089,2) to calculate the tax itself.
in E12 enter:
=C+D to calculate the total with taxes.

I'm not sure that the Help or the Guide where needed for such formulas but, one never knows 😉

Yvan KOENIG (from FRANCE lundi 3 août 2009 17:47:23)

Reply

Answer 5

Aug 3, 2009 9:05 AM in response to KOENIG Yvan

Thank you so much, it worked like a charm!

🙂

Reply

Answer 6

KOENIG Yvan

Level 8

41,819 points

Aug 3, 2009 9:19 AM in response to Brien Tomassetti

Thanks for the feedback

I wish to add that Jerrold responded to you exact question.
I choosed to use two formulas because, on invoices, at least in France, we must display the tax amount as well as the full total 😉

Yvan KOENIG (from FRANCE lundi 3 août 2009 18:17:43)

Reply