IF FORMULA

[HVK1986]

HELLO ALL..

MYSELF HARISH KULKARNI AND I WORK IN A BANK.

I WANTED HELP FOR THE IF FORMULA. I HAVE A DATA AS UNDER


IN CELL A1 IF THE AMOUNT IS >0<=60000 IN CELL B1 IT SHOULD COME AS 20%, IF IN CELL A1 THE DATA IS >60000<=200000 IN CELL B2 IT SHOULD COME AS 25%, LIKE WISE >200000<=500000 35%, >500000<=1000000 50%.


PLEASE SUGGEST ME THE RELEVENT FORMULA.


REGARDS AND THANKS IN ADVANCE

 

[Hui]

In B1: =if(A1<=60000,20%,if(A1<=200000,25%,If(A1<=500000,35%,50%)))

 

[HVK1986]

DEAR SIR HUI,

THANKS A LOT FOR REPLYING, AND POSTING THE FORMULA. MY JOB IS DONE.

THANKU...

 

[SirJB7]

Hi, HVK1986!

Would you be as kind as to write in lowercase next time? Using uppercase in forums and blogs is understood as shouting. Thank you.

Regards!

 

[HVK1986]

@ Sir JB7.

Ok sir.