Cable Forum - Excel: Calculating VAT

Cable Forum (https://www.cableforum.uk/board/index.php)

- General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)

- - Excel: Calculating VAT (https://www.cableforum.uk/board/showthread.php?t=45660)

Re: Excel: Calculating VAT

Based on the conversation above, and the fact that you've been happy with the results generated, then I'd say yes.

That said, I'd do the calculations differently - that's just me though.

i'm going to tidy the posts above up I think..... :erm:

Re: Excel: Calculating VAT

Quote:

Originally Posted by Acathla (Post 34723683)

Correct :)

Thought so - thanks for confirming!

Re: Excel: Calculating VAT

Quote:

Originally Posted by LSainsbury (Post 721833)

So how comes when in calc you do the calculation of 30-17.5% = Net Ã‚Â£24.75 / VAT=Ã‚Â£5.25?

Now confused!!!!!

The 30 is 117.5% of the net not 82.5% 7/47th as a fraction.

If you want to do it that way it is 30-14.89361702127659574468085106383% (or 40/47ths)

Now it is 15% the vat fraction is 3/23rds

---------- Post added at 13:20 ---------- Previous post was at 13:17 ----------

Quote:

Originally Posted by LSainsbury (Post 34723682)

Bump!

Not used my Overtime sheet for a while - had minimal expenses just been put through the tin, but this month I have a few so back to the Excel sheet.

It currently has this formula to work out VAT:

=SUM(E19/1.175)

I take it that should now read this since the rate has changed:

=SUM(E19/1.150)

Correct???

What you really should do for clarity is put a line in it that says VAT RATE and then type the % in the box next to it and then refer all the VAT calcs to that number) Say it is in A27 that woudl be =sum(E19/(1+$A$27))
It's bad spreadsheet practice to put variables in as fixed numbers in multiple cells.

Re: Excel: Calculating VAT

Quote:

Originally Posted by SMHarman (Post 34723758)

What a waste of time - I mean - come on - how often does the VAT rate change.......

:erm:

Errrrrr - right - I see - will do that - good call!