Hello,
I have been going crazy to try and get a formula to do what I want it to do. I've tried nesting different ones and I just am not able to logically tell excel what it is that I want.
I have attached a mockup of my workbook, there are two tabs. The first tab is a list of JOBS and is fairly self-explanatory. The second tab is a TAX RATE TABLE; first column is the name of the county, second column is an abbreviation of that county name, column C is our state tax rate (all cells are 5%), D is for extra county or stadium tax, E is the date that C + D become effective; and F is the total tax rate C+D depending on the effective date. You can see on the highlighted line, the effective date is 4/1/18, when that rate will become 5.5%.
All items on Tab 1 are manual, except Column F - Tax Rate
I want to have column F on Tab 1 filled in automatically from Column F
Tab 2 for the County Abbreviation typed in Tab 1 column H
This I can easily do with the formula that I now have in Tab 1 Column F
However, the tax rate that fills in on Column F needs to be dependent
upon the Date in Tab 1 Column B as well as the Effective Date in Tab 2 Column E
If I leave my formula as it is, then on 4/1/18, Tab 1 column F on ALL the
lines with CAL as the county will change to 5.5%! Only CAL Jobs whose date
in Tab 1 Column B that are after 4/1/18 should change to 5.5% while
the CAL jobs in Tab 1 Column B that were before 4/1/18 should remain at 5%
Bookmarks