Hello, i need a formula to calculate the gross price knowing only VAT rate and VAT amount.
For example.
i know vat rate is 24%
i know the vat amount is 48€
i want to get the 248€ as a result
Any help is much appreciated
Thank you
Hello, i need a formula to calculate the gross price knowing only VAT rate and VAT amount.
For example.
i know vat rate is 24%
i know the vat amount is 48€
i want to get the 248€ as a result
Any help is much appreciated
Thank you
24%=48
Hence 1%=2
100%=100* 2 =200 =Net Amount
Total=200+48 =248
Last edited by JohnTopley; 05-26-2021 at 11:19 AM.
Assuming the value subject to VAT is called Net Value
Net Value * VAT Rate = VAT Amount => Net Value = VAT Amount / VAT Rate
Gross Value = Net Value + VAT Amount = VAT Amount / VAT Rate + VAT Amount = VAT Amount * (1 / VAT Rate + 1)
Thank for replying.
So how will be the formula in cell? Lets say the 48€ is C1 and the vat rate 24% is C2. At C3 i want the result of 248
I am little confused...
Formula for C3=C1*(1/C2+1)
Perfect thank you!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks