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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]CIT rate[/TD]
[TD="align: center"]Maximum Profit[/TD]
[TD="align: center"]Profit[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]22.5%[/TD]
[TD="align: center"]1,500[/TD]
[TD="align: center"]36,500[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]25.5%[/TD]
[TD="align: center"]7,500[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]27.5%[/TD]
[TD="align: center"]35,000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]31.5%[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]CIT rate[/TD]
[TD="align: center"]Maximum Profit[/TD]
[TD="align: center"]Profit[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]22.5%[/TD]
[TD="align: center"]1,500[/TD]
[TD="align: center"]36,500[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]25.5%[/TD]
[TD="align: center"]7,500[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]27.5%[/TD]
[TD="align: center"]35,000[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]31.5%[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
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 !