Complex lookup MidQuarter rate

Topic

New Reply

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.

Reply | Quote

Replies

I may be way off – but its a shot.
Take a look at the attached workbook that uses VLOOKUP formulas.

Reply | Quote

I may be way off – but its a shot.
Take a look at the attached workbook that uses VLOOKUP formulas.

Looks pretty good. Will test drive. Thanks a lot!

Reply | Quote

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.

Reply | Quote