vat

Hi Guys I'm hoping someone can help. I have a spread sheet with all my products which include the purchase price, shipping costs and fees etc. I have a column for the minimum sale price, and this needs to be the break even price after VAT @ 20%, amazon fees, packaging costs etc Here is an...

Hi all, I have hit a problem with my work project and it's one of those where I can't even begin to design the solution never mind implement it! I hope you guys can help! I have provided a sample workbook here. https://drive.google.com/open?id=1u30oLh9SavbDpc3YVfoWGCEGJZ7Aqpeu The process...

Hi all, I am looking to be able to input a figure into a cell and when I press enter, have the cell automatically remove the vat @ 20% I know the calculation is to divide by 1.2, but thats as far as my knowledge takes me! Is there any code I could use to do this. I have a spreadsheet from work...

Hello, I have a spreadsheet in which is added data in 2 columns each month at the end of the sheet, called "NET" and "VAT". I am trying to write a formula that sums entries from last 12 columns "NET" (one formula for last 12 "NET" columns, f.e AK, AI, AG, AE etc) and "VAT" (another formula for...

Hi All, Was directed here by someone after not being able to find a solution online. I have an Excel report that gets sent through to me every week and I always have to unmerge the top two rows so all headings are unmerged and then delete all columns containing the words "Ex VAT", "Inc VAT"...

Hi all Can anyone please help with providing code that would allow me to: 1. Send each of the numbers in column A of a spreadsheet (and indeed any amount of numbers included in column A) eg these numbers:- 238554836 166913834 205963701 343475355 220430231 to...

Hi, want to create a macro to filter all cells in column K, which include the word "VAT Return". The name vat return will be part of a string: For Exampe: Q1 2019 VAT return, or Q2 2019 Vat return. Sub filtering rows("1:1").select selection.autofilter activesheet.range("k4:k100").autofilter...

Can anyone please help me. I want to search for a number (%) contained within in a string of text in another cell. E.G. The data I currently have is listed below: <tbody> Row Column C Column D Column E Tax % New % Tax Code Description 11 0 Albania Non-Recoverable 10% VAT Medical...

Hi Guys I need to have a textbox that shows the nett value before VAT from a Gross value I have a UserForm with the following textboxes: TextBox1 where the user enters the Gross value TextBox2 where the user enters the applicable VAT Rate [default is set to 20] TextBox3 is to contain the Nett...

Hello, I have word invoice template, my problem is in VAT (%) merged cell, whenever I leave VAT (%) cell in excel blank I got this error in VAT merged cell in word !Unexpected End of Formula Thank in advance.

Help please - I am a jeweller trying to work out gross profit from COLUMN A RING PRICE TO CUSTOMER , COLUMN B VAT 20%, COLUMN C. ASSAY FEE 17.50, COLUMN D GOLD PRICE, COLUMN E. TOTAL COST COLUMN F. GROSS PROFIT BASICALLY VAT WORKED OUT AT 20% AND THEN COLUMNS B, C, D, E DEDUCTED FROM...

Looking for help with SUMIFS. I need the sum if Column A contains "53", "Vat" or both. <tbody> Charge Amount C5305-R-D - Duty 83,942 C5315-R-D - Gst Paid 411,816 5315-R-D - Cisf 2,985 5315-E-D - Gst Paid 233,045 153-R-D - Cisf 2,985 153-R-O - Cisf 32,410 VAT-E-D - Customs Vat...

I am looking for help to autofill cells based on VAT codes In column I are the tax codes which are either T1, T2, T9 or T13 in column J I would like to see against either T2 or T9 - 0 For T13 - no result For T1 - column H has the gross amount - in column J I require the VAT included (so if...

I have the following below that if the sumifs formula returns zero, then a zero must be returned, otherwise use the countifs formula However, if the sumifs returns for eg 0.00000000183 or -0.0000000164, then the countifs value will result I would like to amend my formula to exclude all...

Hello all I am new to Microsoft Access and would like to ask a question I have a calculated field which looks at a field called "Total Cost" and divides this by 6 to get the correct VAT value I sometimes want to edit this field if the product has a reduced or no VAT charge Is there a way to...

HI there :) I currently have this formula in my cell =IF(SUM(I4:CD4)=0,"",H4*14%) and I've read a tip regarding rounding for vat to put this formula in =ROUND(B2*1.14,2). How do I merge these 2 formulas to work in one cell?

Hi All, can anyone assist with a formula for the following : <tbody> 609 C E F G H i J K L S T U V 610 Description Prop. Vat Dr Amount Vat Cr Amt Vat Total Days 5% Total 611 2,668,666.46 612 2017-01-30 Loan - In Eaton n 200,000.00 200,000.00 115...

Hi, can someone assist with the a formula for the 2nd example : <tbody> B C D E F G H I K 2 Description Property vat Dr vat Credit vat Bank Transfer 3 Transfer Eaton 100.00 -100.00 100.00 </tbody> Formula does work in cell k3...

Hello Guys, I have a list of CR Numbers in Column A (count 4000) and my purpose is to extract "VAT Number" and "Arabic Name" registered against the CR number on the VAT Website. For ease, I am putting a sample CR as "1010069143" Following is the code developed by me and I am facing the...

I am trying to convert an invoice summary spreadsheet into something I can import into another system. The original file has data which is located in different places on different tabs so I want to search each tab for a specific text string and then either return the value in the nth cell to...