Excel help 2007

Question

I want to create  formula as following criteria. Please, help.

i)  House Rent will be- of basic

up-to Tk. 5000     55% but not less than Tk2500

Tk.5001-Tk.10800  50% but not less than Tk2800

Tk.10801-Tk.21600  45% but not less than Tk5400

Above Tk. 21600    40% but not less than Tk9700.

ii) Subsistance Allowance will be-

    Basic*20%    but not less than Tk.1500 and not more than Tk.6000

Answer 1

I'm not sure what you mean by "Tk" can you give some more details? Thanks.

Answer 2

Tk means Taka,  I mean currency.