IF condition

[pallu]

Hi

I need your help in if condition for attached file marked in green

IF D2 = NJ IF Annual ctc UP TO 300000= FBP= 5000 above 300000 FBP = 6500
IF D2= SR IF Annual ctc UP TO 250001 to 300000 = FBP= 5000 above 300001= FBP6500
I have tried the formula it shown as circular reference

pls help

regards
pallu

 

[Hui]

two solutions

N2: =IF(AND(D2="NJ",F2<=300000),5000,IF(AND(D2="NJ",F2>300000), 6500,IF(AND(D2="SR",F2<=300001),5000,IF(AND(D2="SR",F2>300001), 6500,0))))-M2

or

N2: =IF(OR(AND(D2="NJ",F2<=300000),AND(D2="SR",F2<=300001)),5000, IF(OR(AND(D2="NJ",F2>300000),AND(D2="SR",F2>300001)),6500,0))-M2

Copy down

 

[pallu]

hi thanks both solution are working fine...

 

[shrivallabha]

If NJ and SR are the only values in D2 then following should work correctly.
=IF(D2="NJ",IF(F2<=300000,5000,6500),IF(F2>300000,6500,IF(AND(F2>250000,F2<=300000),5000,"Case SR LEQ 250000")))

 

[pallu]

Hi

I have user the formula but I couldn't add the another condition in the above

Ø range 2.79 to 3.00 lac , 6500.

Ø 250010 to 2.789 lac ,5000.

Ø 250000 and below is 0 break up.

please help the formula

 

[shrivallabha]

Hi

I have user the formula but I couldn't add the another condition in the above

Ø range 2.79 to 3.00 lac , 6500.

Ø 250010 to 2.789 lac ,5000.

Ø 250000 and below is 0 break up.

please help the formula

Can you clarify above requirement little bit more? Are NJ/SR conditions mentioned in post#1 applicable? If yes, how do they apply?