Change applied % after a certain value reached?
Hi,
I'm trying to put together a simple spreadsheet to estimate tax due on income. I have a horizontal line containing the date (months) and under that a manually entered value for income in each monthly period.
As we all know, the applied tax alters depending on income to date. I have a row that estimates the tax for each monthly period by applying a precentage. I'd like to get the percentage to change to a different value when income reaches a certain value.
How could I do that? I know the percentage values that can apply so I could have some cells with those values in. The formula applied to the income could reference one of the cells to calculate the tax but how would I get it to reference another cell when a certain value of income had been reached?
Have I made myself clear ?
|