Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am stuck with manually recalculating some costs using the US Mid-Quarter tax tables. These tables tell you the rate you must use based on the quarter of the year you place an asset in service. For each year of the asset's life, a percentage can be expensed. I have the tables in the attached workbook. I need to find a way to get a formula to find the right period and cumulative percentages to apply to an asset. I have a sample which shows an asset purchased in the second quarter of 2006, now 3 years old based on the difference in calendar years. I have the quarter identified through a formula I received from this forum. Is is possible to somehow get two formulas to provide me with the correct period and cumulative percentages. I've taken a stab at Index match but without much success so far. Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I may be way off - but its a shot.
    Take a look at the attached workbook that uses VLOOKUP formulas.
    Attached Files Attached Files
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='reimer' post='797531' date='12-Oct-2009 12:31']I may be way off - but its a shot.
    Take a look at the attached workbook that uses VLOOKUP formulas.[/quote]
    Looks pretty good. Will test drive. Thanks a lot!

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I decided to combine the formulas so they could be copied down the rows.
    Take a look at the attached workbook.

    If the formulas work the way you want them to, you can copy them down the rows.
    Attached Files Attached Files
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •