+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    34

    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. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,125

    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
    Last edited by JohnTopley; 05-26-2021 at 11:19 AM.

  3. #3
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B 2016
    Posts
    719

    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. #4
    Registered User
    Join Date
    07-09-2014
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    34

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

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

  5. #5
    Valued Forum Contributor
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B 2016
    Posts
    719

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

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

  6. #6
    Registered User
    Join Date
    07-09-2014
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    34

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

    Perfect thank you!!!

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,125

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

    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.

  8. #8
    Registered User
    Join Date
    07-09-2014
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    34

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

    Quote Originally Posted by JohnTopley View Post
    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.
    Done it Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 01-20-2018, 01:49 PM
  2. Derive Gross Pay plus Payroll Taxes from a Gross Amount
    By JackJack185 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-09-2017, 03:56 PM
  3. [SOLVED] Excel formula to calculate a conversion rate knowing a $USD amt and a $AUD amt
    By BazzaBit in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-01-2014, 09:35 PM
  4. Replies: 2
    Last Post: 03-27-2014, 05:13 PM
  5. Replies: 6
    Last Post: 04-22-2013, 12:50 AM
  6. Replies: 5
    Last Post: 04-01-2012, 04:20 PM
  7. Replies: 2
    Last Post: 09-25-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1