Need help in use of IF function

[Santosh080]

Hello Friends

Today my Boss give me some work in excel but i face some problem in it. So i need your help.

I have one excel file like below,


[TABLE="class: outer_border, width: 128, align: left"]
<tbody>[TR]
[TD="width: 64"]Amt[/TD]
[TD="width: 64"]% of Cash[/TD]
[/TR]
[TR]
[TD="align: right"]48000[/TD]
[TD="align: right"]55[/TD]
[/TR]
[TR]
[TD="align: right"]55000[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD="align: right"]32000[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]56000[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD="align: right"]110000[/TD]
[TD="align: right"]78[/TD]
[/TR]
[TR]
[TD="align: right"]130000[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD="align: right"]250000[/TD]
[TD="align: right"]66[/TD]
[/TR]
[TR]
[TD="align: right"]260000[/TD]
[TD="align: right"]74[/TD]
[/TR]
</tbody>[/TABLE]
















I have given these conditions to apply on the above table.

[TABLE="class: outer_border, width: 393"]
<tbody>[TR]
[TD="colspan: 2, align: center"]Two Conditions
[/TD]
[TD]Outcome after apply of condition[/TD]
[/TR]
[TR]
[TD]if Amt is upto 50000[/TD]
[TD]55% or above[/TD]
[TD]BR[/TD]
[/TR]
[TR]
[TD]if Amt is upto 50001 to 100000[/TD]
[TD]65 % or above[/TD]
[TD]BR[/TD]
[/TR]
[TR]
[TD]if Amt is upto100001 to 200000[/TD]
[TD]75% or above[/TD]
[TD]BR[/TD]
[/TR]
[TR]
[TD]if Amt is upto 200001 to 500000[/TD]
[TD]60% or above[/TD]
[TD]RO
[/TD]
[/TR]
</tbody>[/TABLE]


I can not figure out how to use the IF function or any other function in this situation. I want to apply the TWO conditions so that i get the out come either BR or RO in the adjacent column in the first table.

 

[Special-K99]

You havent answered my question

32000 32%


32000 is up to 50000 but the percentage 32% is NOT 55% and above so what are you epexcting the result of this to be?