+ Reply to Thread
Results 1 to 6 of 6

Tax calculation

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Tax calculation

    Hi,

    Would need the tax calcualtion based on the rate mentioned in the attached sheet. Pls hlep
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Tax calculation

    Please Login or Register  to view this content.
    Try the above (this was originally posted by Glenn Kennedy in another thread of this forum)
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: Tax calculation

    oh...it works well....thanks a lot

  4. #4
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: Tax calculation

    Hi,

    Can i get this imlemented to attached sample formula with little different requirement?

    Note:- based on the statwise tax slab, whenever i change teh state it should calculate teh amount based on that and Normal tax will be applicable for all states.

    Attached the sample sheet. formula should be linke tod the slab sheets so that whenever slab chagnes i can update it in the list and get the resulst automatically.
    Attached Files Attached Files

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Tax calculation

    I modified your file little bit see the attached file
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: Tax calculation

    Hi,

    You have given this within shortspan of time...Thanks a lot...have a good day

+ 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: 0
    Last Post: 05-17-2014, 10:18 PM
  2. manual calculation for one worksheet by F9 and auto calculation for other sheet
    By rayshimadri in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2013, 06:16 AM
  3. Replies: 1
    Last Post: 09-24-2013, 03:03 AM
  4. Replies: 4
    Last Post: 07-23-2013, 07:51 AM
  5. Replies: 1
    Last Post: 01-15-2013, 08:51 AM
  6. [SOLVED] Conditional statement calculation based on result of previous calculation.(Need some help)
    By takeprofit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2012, 01:45 AM
  7. Add an amount from a calculation to a cell with a calculation (Sample attached)
    By aiwnjoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2010, 10:41 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