+ Reply to Thread
Results 1 to 4 of 4

Calculate VAT

  1. #1
    Registered User
    Join Date
    02-07-2023
    Location
    United States
    MS-Off Ver
    0.8
    Posts
    18

    Calculate VAT

    Hello its the noob again :laughing:,

    I can't find how to use number variables, for example I have a variable Tax included from an excel document that look like that : 829,00 €

    I want to make a variable called taxincl with the value 829 (only numerical without the euro sign) :
    taxincl = copied value

    I want to calculate the price before VAT 20% which is taxincl / 1,2 and make a variable with that value called beforetax :
    beforetax = taxincl / 1,2

    I want to calculate the VAT which = taxincl - beforetax make a variable called vat with that value :
    vat = taxincl - beforetax

    Once I will have my 3 numerical variables, taxincl, beforetax and vat, I will be able to paste them in a document on the net but I don't understand how you make numerical variables in KM,

  2. #2
    Registered User
    Join Date
    02-07-2023
    Location
    United States
    MS-Off Ver
    0.8
    Posts
    18

    Re: Calculate VAT

    Quote Originally Posted by bojef View Post
    Hello its the noob again :laughing:,

    I can't find how to use number variables, for example I have a variable Tax included from an excel document that look like that : 829,00 €

    I want to make a variable called taxincl with the value 829 (only numerical without the euro sign) :
    taxincl = copied value

    I want to calculate the price before VAT 20% which is taxincl / 1,2 and make a variable with that value called beforetax :
    beforetax = taxincl / 1,2

    I want to VAT Calculator South Africa which = taxincl - beforetax make a variable called vat with that value :
    vat = taxincl - beforetax

    Once I will have my 3 numerical variables, taxincl, beforetax and vat, I will be able to paste them in a document on the net but I don't understand how you make numerical variables in KM,
    thanks in advance for any help

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,450

    Re: Calculate VAT

    If A2 has the value, then:

    Amount before VAT (B2):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    VAT (C2):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Total (D2):
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,450

    Re: Calculate VAT

    If you convert your data to a Structured Table, you could use something like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.




    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

+ 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: 7
    Last Post: 04-19-2023, 11:53 AM
  2. Replies: 2
    Last Post: 04-17-2023, 02:46 PM
  3. Index Match to calculate data - Filter calculate
    By Tgbell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2019, 01:46 PM
  4. Code to Calculate the product of two matrices won't calculate
    By njrobby in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2015, 01:37 AM
  5. Target.Calculate to Me.Calculate breaks Copy/Paste
    By vayana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2013, 10:36 AM
  6. [SOLVED] Calculate values in col B based on value in col B but only calculate final 5 instances
    By arnoldd99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2013, 11:53 AM

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