How to Calculate VAT in Excel?

[@cindycubbin2932]

👍🏼😀

[@sunyounglee1602]

Excellent! Clearly explained. Thank you!

[@computertutoring]

thanks for saying

[@AndreaGolding-e7e]

Fantastic! Thank you and so clearly explained 🙂

[@computertutoring]

Thanks really appreciate it

[@VishalSengupta1984]

Man, you saved me a lot of time and effort. But mostly, you helped me save face. Liked and Subscribed! Thank you!

[@computertutoring]

You'd be amazed at how many don't know this. I didn't too! Glad you kept your rep.

[@mwilachimfwembe7746]

Thanks this really helped me

[@computertutoring]

So glad it did and thanks for the comment

[@shabanshabanov6432]

Very useful video
Thank you Simon

[@computertutoring]

You're very welcome thanks for the comment

[@geezer01456]

omg it works, watched all the other useless videos on % but this works, awesome!

[@computertutoring]

I was in exactly the same boat as you, so thought this VAT tutorial would be just the ticket 😁

[@marineisribeiro6782]

Thank you, it is very well explained

[@computertutoring]

Cheers 🍺🍺

[@cristianfrunza]

Thank you! Worked perfectly!

[@computertutoring]

Cool

[@StuMazza180]

Excellent video. Thanks

[@computertutoring]

Glad it helped

[@poppyballon6374]

Really well explained and easy to follow!! Thank you!

[@computertutoring]

Thanks for saying. 😁

[@gregkeet]

Thank you Simon 👍👍

[@computertutoring]

You're very welcome 👍🏽

[@PenelopeRyder]

If I wanted to see the Vat amount in a column instead of only 20% what would I do?

[@computertutoring]

Good Question: from the gross amount: =C3-C3/(1+B3) This is the understanding that C3 contains the gross amount and you want a VAT column

[@JonMoseley]

Thank you so much 👍🏻👍🏻👍🏻

[@computertutoring]

😊

[@sheiladillon9022]

Thanks!

[@computertutoring]

😀

[@ianmoleary1]

Great video, clear and easy to follow. Thanks very much

[@computertutoring]

Glad it helped and appreciate you saying so

[@shohid52]

Really great job

[@computertutoring]

Thanks much appreciated

[@mahdifawaz]

thank you 👍

[@computertutoring]

Thanks for saying

[@ruelegarridigan1411]

Thanks a ton man 👍

[@computertutoring]

Glad it'd helped - I always have to think before doing this calculation

[@AttaUrR]

in which condition the VAT is to be claimed example the "VAT claim in purchases and other input" "VAT Claim in sales and other output"

[@paruppuvadai]

Y using 1

[@computertutoring]

To work out the percentage 1 in Excel is equivalent to 100%

[@oneummah1976]

why you use 1 in formula

[@computertutoring]

1 is 100% percentages are decimals in Excel. So
=A2*(1+.2) is the same has A2 * 120%

[@iraribeiro8029]

Topppppppppp

[@computertutoring]

Thankssssssss 😉

[@insz6620]

[@aftabkhedekar7578]

Thank you Sir

[@computertutoring]

No worries at all!