SOLVED

New Contributor

# Excel rules

Hi,

I have a problem.

I want a rule where i can write a sum like 2 430 000 and that the first 1 000 000 does one calculation
the second 1 000 000 does another and the third a third calculation.
So i want to write in one cell 2 430 000 and that it does the calculation like this
1 000 000 x 25%
1 000 000 x 30%
430 000 x 32%.

Does anybody know how to do this?

4 Replies
best response confirmed by AnasT10 (New Contributor)
Solution

# Re: Excel rules

=IF(C2>2000000,(C2-2000000)*0.32+1000000*0.3+1000000*0.25,

IF(AND(C2>1000000,C2<=2000000),(C2-1000000)*0.3+1000000*0.25,

IF(C2<=1000000,C2*0.25,)))

Is this what you are looking for?

# Re: Excel rules

Hi,
Thank you so much! It seems right but i cant put it in the excel, i get an error.

I have written in the cell C2 - 2 430 000

Then tried to put this in in cell E3
=IF(C2>2000000,(C2-2000000)*0.32+1000000*0.3+1000000*0.25,(AND(C2>1000000,C2<=2000000),(C2-1000000)*0.3+1000000*0.25,(C2<=1000000,C2*0.25,)))

# Re: Excel rules

=IF(C2>2000000,(C2-2000000)*0.32+1000000*0.3+1000000*0.25,

IF(AND(C2>1000000,C2<=2000000),(C2-1000000)*0.3+1000000*0.25,

IF(C2<=1000000,C2*0.25,)))

If you enter the suggested formula it should work like in attached file. Enter 2430000 in cell C2 instead of 2 430 000.