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 ?

Unless you attach a sample of your workbook, someone would be able to help you out.