tax

  1. U

    Tax Calculation formula

    Hi All, I have a formula I am having a heck of a time with, I need this to say, E8+E11*6% for the first 5000 and then over 5000 would then be charged 6%. The catch is I need it to retain the amount of the 1% for the first 5000 ($50) E8+E11)*7% Eg 5000 would result in $350 Eg 6750 would...
  2. A

    Is Vlookup appropriate

    I have a spreadsheet I need to add tax ids to but tax ids are on the second tab. I want to match it with vendor number. Would vlookup be appropriate and how would it work? Say the vendor numbers are in column A on both tabs but the tax Id is on tab 2 in column b.
  3. muhammad susanto

    Custom Number Input Tax Ratio

    hi all.. how to make custom number format like this <tbody> entry-input expected result - display 2% Tax Ratio (2%) 10% Tax Ratio (10%) </tbody> any help, thank in advance.. .sst
  4. D

    VBA Consolidation Code

    Hi all, I need help with a VBA Code. I have an excel table that looks like this: <tbody> <tbody> PO Status Description Vendor Department Date Approved Project ID Before Tax Tax After Tax Invoice Number Invoice Date Invoice Amount 100012 Closed Replenish Motors 1935.70 AIT 750...
  5. Y

    reverse-percentage-calculation-on-percentage-fee

    I have a calculation Problem In My Application In which I need to Calculate Reverse Amount From Grand Total Amount. I Need Logic/Formula for It Need you guys Help. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...
  6. Z

    Flip data from horizontal to vertical format for uploading

    Hi, Is it possible to change data format in Excel. My data in excel is as follows: Name of GL GL Code Jan-19 Feb-19 Mar-19 Apr-19......until Dec-19 Salaries 8205 $100 $200 $300 $400 $1200[/PHP][/HTML] Tax...
  7. leopardhawk

    CONCAT function

    I would like to add a formula to this cell (B53) to replace the two occurrences of the word "Dale". The cell currently contains approximately 822 characters. Excel limits the text within a formula to 255 characters. I understand that the CONCAT functions allows for putting text strings...
  8. tlc53

    Return cell value if conditions met, without duplications

    Hi, I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve; Car Type B14:B23 Tax Treatment E14:E23 Private % F14:F23 Input Data B28:B37 I would like the Input Data B28:B37 to be pre-populated depending on what the Tax...
  9. K

    Automatically update Main Sheet from 3 or more other Sheets

    Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...
  10. S

    tax calculation

    Hi I am using the if function in the calculation of tax . am looking if it is possible to use vlookup index match to calculate the tax amount
  11. leopardhawk

    Need help adding text to a formula

    These two formulas are in adjacent cells (I98 and J98) and I want to combine them into one formula and add a bit of additional text. This formula is returning "2019 OAS Recovery Tax threshold" without the quotes. =YEAR(NOW())&" OAS Recovery Tax threshold" This formula is returning $77580.00...
  12. E

    Gross salary from Net Salary

    Hi please I need urgent excel help to find the gross salary, given the Net salary in Ghana Net salary( example)....... 2,723.50 S.S.F............................5.5% P.F...............................3% NB: (S.S.F. and P.F. are deducted from the gross salary before arriving at chargeable...
  13. leopardhawk

    IF statement

    Hello forum friends, I am having an issue with a formula that I need to modify. I think I am missing an IF statement? Not sure. I know that this is going to be a fairly complex formula and I will be grateful for any help that I receive. The formula in question resides on the 'income analysis'...
  14. N

    Format Cells custom set up

    I am looking to use format cells options to have a prompt that shows up in the cell to give direction such as "Enter Work Code Here" or " Work code Here" when there is nothing in the cell. Once its been entered, the messages is not long displayed unless the number and letters are entered...
  15. P

    Calculating IF formula for Tax & NI Deductions..

    Hi All, Any help is appreciated, I've been playing about with this trying to get the formulas right, assuming an IF formula, but not sure how to separate if it requires an answer between a certain range. For example, I'm trying to write cell formulas so whatever Gross income is entered it...
  16. E

    Using Excel to calculate income tax

    Hi, I am trying to use Excel to calculate income tax. The tax system has a number of rates applied to each band as follows Lower Limit (H22) Upper Limited (I22) Rate (J22) Tax Free Allowance (G23) £0...
  17. P

    How to select the correct table for VLOOKUP to read from? (Payroll Taxes)

    Help! I have been developing a payroll environment in excel for my business to use. After overcoming several hurdles, I find myself stuck at one last one. In the workbook I have an Employee Info sheet wherein I contain indicators for their tax bracket (Married or Single) and the number of...
  18. R

    Round off based on third decimal place

    Hi dears, I would like to know the easiest way to do this in excel and I will really appreciate your help. If the third decimal place is 1 or 2 or 6 or 7 round down to nearest 5. If the third decimal place is 3 or 4 or 8 or 9 round up to nearest 5...
  19. M

    Combined index & match formula

    Hello Mr XLers! This formula below only works when the date in my sales Tax Table matches the date in my materials date column. I need to be able lookup tax % with after 1/1/2019 which is the beginning date in my Sales Tax Table. Any help would be awesome! :confused::confused::confused...
  20. P

    conditional calculation

    sir, This is Income Tax calculation where for 1st 2,50,000 rupees no tax. For the next 2,50,000 rupees tax is 5%. Above 5 lakh but below 10 lakh tax, it is 20%. Above 10 lakh, tax is 30%. if taxable income is 450000(4.5 lakh) for 250000 nil tax upto 500000 5%...

Some videos you may like

This Week's Hot Topics

Top