HVCompleto
New Member
- Joined
- Aug 28, 2017
- Messages
- 5
Good afternoon,
I am trying to apply a tax bracket in my model, and wanted to use a simple formula to calculate my tax expense, I have a table displayed as follows
<tbody>
</tbody>
I wanted a formula similar to this:
{=MIN(C2-B2:B5,IF(B3:B6=0,C3,B3:B6)-B2:B5)*A3:A6}
However, the MIN fuction returns just one value, instead of an array with the minimus between two values, which is what I would like.
Is there any simple way to solve this issue? I have achiveved the same with nested IF functions, but given that this formula is supposed to be auditable, a long nested if function is not ideal.
Thank you !
I am trying to apply a tax bracket in my model, and wanted to use a simple formula to calculate my tax expense, I have a table displayed as follows
A | B | C | |
1 | CIT rate | Maximum Profit | Profit |
2 | 0 | ||
3 | 22.5% | 1,500 | 36,500 |
4 | 25.5% | 7,500 | |
5 | 27.5% | 35,000 | |
6 | 31.5% |
<tbody>
</tbody>
I wanted a formula similar to this:
{=MIN(C2-B2:B5,IF(B3:B6=0,C3,B3:B6)-B2:B5)*A3:A6}
However, the MIN fuction returns just one value, instead of an array with the minimus between two values, which is what I would like.
Is there any simple way to solve this issue? I have achiveved the same with nested IF functions, but given that this formula is supposed to be auditable, a long nested if function is not ideal.
Thank you !