Nov 18 2021 04:21 AM
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?
Nov 18 2021 04:33 AM
Solution=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?
Nov 18 2021 05:04 AM
Nov 18 2021 05:29 AM
=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.
Nov 18 2021 10:17 AM
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??
Nov 18 2021 04:33 AM
Solution=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?