SOLVED

Excel rules

Copper Contributor

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 (Copper Contributor)
Solution

@AnasT10 

=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?

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,)))

@AnasT10 

=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.

You are a KING!@OliverScheurich 

I hade to change IF to Om (swedish) then it worked. Thank you so much 4 your help! Can I give something back??

1 best response

Accepted Solutions
best response confirmed by AnasT10 (Copper Contributor)
Solution

@AnasT10 

=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?

View solution in original post