IF Formula Error

[JawaharPrem]

Hi Team,

Conduction
if camp P2P and days <=90" should updated as "A"
if camp MNPand days <=120" should updated as "A"

I tried in OR,AND,XOR please I not getting proper output please help on same. sample data enclosed for reference.


Thanks Jawahar

 

[Nebu]

Hi:

Your explanation and your spreadsheet is not matching, could you be more specific on this?

Thanks

 

[bosco_yip]

Maybe,

=IF(OR(AND(A2="P2P",B2<=90),AND(A2="MNP",B2<=120)),"NAS","CHURN")

Regards

 

[JawaharPrem]

Hi Bosco,

Thanks its working...