formula Calculate interest by amount

[abdelfattah]

hello
I would like to know how interest is calculated by amount

For example, from the amount of 3000 to 25000, interest is calculated as 20%

From the amount of 25000 to 50,000 the interest is calculated 22% g

From the amount of 50000 to 100,000, interest is calculated 25% g

Thank you very much

 

[cortexnotion]

If you need the amount + interest:

=IF(AND(A1>=3000,A1<25000),A1*1.2,IF(AND(A1>=25000,A1<50000),A1*1.22,IF(AND(A1>=50000,A1<100000),A1*1.25,0)))

If you need just the interest:

=IF(AND(A1>=3000,A1<25000),A1*0.2,IF(AND(A1>=25000,A1<50000),A1*0.22,IF(AND(A1>=50000,A1<100000),A1*0.25,0)))

 

[abdelfattah]

it some thing wrong the value is not right

 

[cortexnotion]

Hi abdelfattah, in what way is it not right?

 

[abdelfattah]

no no every thing is ok i'm wrong your formulas works very well thank so much

 

[JackDanIce]

Alt suggestion, try:

=A1*IFERROR(LOOKUP(A1,{3000,25000,50000},{0.2,0.22,0.25}),0)

 

[abdelfattah]

wow ! JackDanlce i'm surprised this formula despite it is very short but works perfectly , thanks buddy

 

[JackDanIce]

You're welcome