Formula for calculating gross price knowing only VAT rate and VAT amount

1. Formula for calculating gross price knowing only VAT rate and VAT amount

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

2. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

24%=48

Hence 1%=2

100%=100* 2 =200 =Net Amount

Total=200+48 =248

3. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

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)

4. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

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...

5. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

Formula for C3=C1*(1/C2+1)

6. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

Perfect thank you!!!

7. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

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.

8. Re: Formula for calculating gross price knowing only VAT rate and VAT amount

Originally Posted by JohnTopley

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.
Done it Thanks!

There are currently 1 users browsing this thread. (0 members and 1 guests)