Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell colour change when set markers are reached | New Users to Excel | |||
Inserting the same value until the same value is reached again | Excel Discussion (Misc queries) | |||
Change cell color when a percentage is reached | Excel Discussion (Misc queries) | |||
Add one until 171 is reached | Excel Worksheet Functions | |||
Can you change the default font applied to comments? | Excel Discussion (Misc queries) |