Formula to collect charges

[Foncesa]

Hi,

Amount Column M. I want to collect charges if the amount is less than 5,000/- then 50/- as charges,
above 5.000/- to 10.000/- charges of 100/- and above 10.000/- charges of 200/- in Column N.

Formula for this.

Thanks

[Paul_Hossler]

"Please"?

Sample?

[Foncesa]

"Please"?

Sample?

Sample File::28374

[SamT]

=CHOOSE(IF($M2<5000,1,IF($M2<10000,2,3)),50,100,200)

If $M2 => 10000 then choose 3

Start in Row 2, then copy the formula down. Expand the formula with additional Ifs and Choices.

[p45cal]

or:
=INDEX({50;100;200},MATCH(M2,{0;5000;10000}))
or:
=VLOOKUP(M2,{0,50;5000,100;10000,200},2)