Formula to collect charges

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

"Please"?

Sample?

Quote:

---

Originally Posted by Paul_Hossler

"Please"?

Sample?

---

Sample File::Attachment 28374

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

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