Ask Your Question
0

How can I work out tax on a invoice? [closed]

asked 2013-01-22 19:44:43 +0100

mrooks1984 gravatar image

updated 2013-01-23 09:02:59 +0100

qubit gravatar image

Hello all i am trying to work out how to work out tax on my invoice i have built

I have a sub total box, a shipping box, a tax box and a total. I currently have the following to work it out, but it doesn't want to work out the tax: E26+E27+E28

  • E26 is the sub total box
  • E27 is the shipping button
  • E28 is the tax box

At the moment when i put 20% in E28, I get the sub total .20 in the amount due.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 20:54:31.829961

2 Answers

Sort by » oldest newest most voted
1

answered 2013-01-23 02:17:15 +0100

m.a.riosv gravatar image

You are summing the percentage tax, not the tax amount.

Total =(E26+E27)*(1+E28)

edit flag offensive delete link more
0

answered 2013-01-23 11:47:37 +0100

mrooks1984 gravatar image

Great thanks very much

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-01-22 19:44:43 +0100

Seen: 423 times

Last updated: Jan 23 '13