+ Reply to Thread
Results 1 to 2 of 2

mdv

  1. #1
    mdv
    Guest

    mdv


    Hi
    This may be simple to most, so could you please help :

    I want to work out V.A.T. each month in exel instead of a calculator
    then inputting it.

    I have aabout 20 customers that i bill each month and i need to charge
    VAT @17.5%.

    Their monthly VAT to be charged is in 1 column so i want to get the VAT
    amount in the next column, then the total in the next.

    Could someone please tell me how?

    Thanks

    M D V


    --
    mdv

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    all you need to do is what you have described. So if the monthly bill is in cell A10, in cell B10 put =A10*.175 and in C10 =A10+B10

    Ed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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