tax

Dear All, Please help i have below report with me i want to combine some field <colgroup><col><col><col><col><col></colgroup><tbody> Below is the data available Transaction Date Transaction Description Transaction Code Net Amount Name 1/21/2018 Charges 1 1000 718.34 AB...

Sir, I am getting 12 lakh rupees annual salary. While paying tax, for 1st 2.5 lakh tax is nil. For next 2.5 lakhs 5% tax i.e. 12,500. For next 5 lakh, 20% tax i.e. one lakh. Above 10 lakhs, 30% tax i.e. 60,000. So, I pay 0 + 12500 + 1 lakh + 60000 = 1,72,500. How can I compute through a formula...

I am creating a quote form that has a check box for sales tax. On sheet1 the tax has a check box and sheet2 has a line for the sales tax included, which only shows if the check box is clicked. My code works when I test it (if I am on sheet2 viewing) UNTIL I enable the macro for the check box...

Hi, I am stuck and need some help please. In my excel workbook I have two worksheets namely "Payroll Register" & "TAX Rates & Rebates" I am trying to reflect the employee's TAX Rebate based on his/her age as per the following table; The "Payroll Register" worksheet contains the employee's...

Hello - I need help form excel experts I want to prepare a report in the following format. If I need Employees Report CPR Wise, it should be like this Month - CPR No - Payment Date - Amount jul - 01-07-17 - 31-07-17 - 300 Aug - 01-08-17 -31-08-17...

I have 3 main sheets 1. Employee Tax 2. Supplier Tax 3. Student Tax I have more 12 Sheets of each month and each sheet have combined data of all the above main sheets I want to automatically copy data from all the 12 sheets to the 3 main sheets.

Hi All, I like to prepare a credit card import file from a csv file. Based on the code and description, expense gl will be inserted and based on province tax will be calculated. I am trying to figure out how to insert new line to do this calculation automatically. Is there any program i can use...

I would like a quick and easy formula to help calculate profit. Scenario. Suppose I purchased 100 Iphone8 at $1000 each plus 15% tax. In excel: A1=100 B1=$1000.00 C1=15% I tried to sell them and nobody would pay me over $1000.00 for them. So I looked around and found another provider that...

looking to fine all data that matches 2 criteria and put in sheet2. The data is made up of number company % total Tax and a y I want to find a company and all the "y" it has

Excel 2007. Cell A1 contains amount in numerical. Tax to be calculated on this amount. If A1<=250000 then no tax. If >250000 and <= 500000, then (A1-250000)*10%. Upto this I am comfortable with the formula, =IF(A1<=250000,0,IF(A1<=500000,(A1-250000)*10%)). There is a concession...

Sir,Need a formula to calculate tax slabs: Up to 2,50,000- Nil <colgroup><col width="35" style="width: 26pt;"><col width="268" style="width: 201pt;"><col width="197" style="width: 148pt;"><col width="200" style="width: 150pt;"></colgroup><tbody> 2,50,000 TO 5,00,000 -5% OF THE AMOUNT...

Excel 2007. Cell A1 : contains income in numerical, for example 1500000 Cell B1 : contains category in text. The text will be either GENERAL or SRCTZN B1 will display only GENERAL or SRCTZN. Cell C1: contains formula to calculate Tax for GENERAL category. Cell D1...

Hi Guys, Anyone who knows how option buttons work in excel macro? So what I want to happen is I have two option buttons (for example, option A = with tax, option B = without Tax) Then, I will hit a button (let's say a trigger button) to compute a certain amount that is affected whatever option...

Trying to do some income tax reporting for example if A1 income is X multiply by the following if its X do this instead. I am fairly new to VBA but how do I make it auto fill a range for example A1:A10? Here is the code I wrote and if there are better ideas I am open to that. Dim income...

In the attached spreadsheet I need to get to a gross margin percentage in column H that takes into account that the contract value includes 10% sales tax (would like to do this without adding a column that is the contract value without the sales tax.) I got as far as a formula that produces the...

Hello, Im trying to figure out a formula but I'm struggling to even describe it to search for it online. Below I have in Table 1 a list of countries, an invoice amount, and the currency the invoice was in. In table 2 I have the countries, their native currency and the tax amount. So i want...

Hello, I have been trying to solve a problem that involves using three different variables (Depth, Production level, and Year) to retrieve a number from a table. What I want is, given a certain production level (which can be any number), a depth (which will be one of the three options below)...

Hi, I am trying to set up solver to determine the best possible tax distribution of income (variables) across multiple entities, based on their initial existing income, in order to minimize their gross tax payable (objective). My main constraint is a cell which must equal zero. When the...

I have a pretty large spreadsheet to enter all our company's vehicle maintenance logs. I have 3 columns 1. Cost 2. Tax 3. Total Cost. Currently I have it selecting the sales tax from another cell but the problem I am starting to run into is that not all of the places we take the vehicles to...

I'd like to calculate the amount of withholding for the federal taxes based on the current IRS rates. I could use a nested IF statement, but I'd prefer something using the actual table provided by the IRS, making it easier to update when the new tax codes come out. To wit, the single, biweekly...