# 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  Register To Reply

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  Register To Reply

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)  Register To Reply

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...  Register To Reply

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

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

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

Perfect thank you!!!  Register To Reply

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.  Register To Reply

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!  Register To Reply

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