I landed your video by searching something else but I loved watching which i was doing in another way. I have learned something interesting here. however I was searching that if i enter only vat amount in a column, how can I get net amount and gross amount automatically in next 2 columns? for the example I have a figure that is 5 percent TAX of 100 which is 4.76. so if I add 4.76 in any column how wold I get gross amount and net amount automatically could you please explain?
Hi Good question, if your data is in a table that can help or if you don't want to use tables you can enclose the vat formula in an IF statement sort of =IF(E6"",[Do the formula],"")
Hi this in Nambo I need to know how can i get total of vet in one cell with different vet rates Like 20% vet all in one cell 5% in other I will send you a pic to understand it better We pay 3%and 8% here and in the end of bill we calculate the vet so how can i get total automatically in the cell
GREAT, THANKS A MILLION
No worries!! Thanks for commenting!
Love it!
Thanks! Now there's no excuse to do your own VAT return. 😉
You done GREAT JOB Thank you
Thanks my friend - means a lot
Hi, thanks for the video. Made my life SO much easier.
Glad it helped 👍🏽
Great 👍
Wanna follow along?
www.computertutoring.co.uk/excel-tutorials/accounts-excel/excel-vat-formula/
😀Great Job!
Thanks, hopefully this is easy to follow
I landed your video by searching something else but I loved watching which i was doing in another way. I have learned something interesting here. however I was searching that if i enter only vat amount in a column, how can I get net amount and gross amount automatically in next 2 columns? for the example I have a figure that is 5 percent TAX of 100 which is 4.76. so if I add 4.76 in any column how wold I get gross amount and net amount automatically could you please explain?
Hi Good question, if your data is in a table that can help or if you don't want to use tables you can enclose the vat formula in an IF statement sort of =IF(E6"",[Do the formula],"")
@@computertutoring I'm so glad with your reply. You are a great tutor 😀 I appreciate yr prompt response
Hi this in Nambo
I need to know how can i get total of vet in one cell with different vet rates
Like 20% vet all in one cell
5% in other
I will send you a pic to understand it better
We pay 3%and 8% here and in the end of bill we calculate the vet so how can i get total automatically in the cell