If condition [Closed]

- - Latest reply: aquarelle
Posts
7241
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
November 22, 2019
- Jan 9, 2016 at 05:47 AM
if a2=mathura then result plm a2=agra and b2<=500 then result pla otherwise result pl
agra 100 pl
mathura 121 plm
bareilly 500 pl
badaun 544 pl
sitapur 701 pl
agra 502 pla
please solv my problem

See more 

1 reply

Posts
7241
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
November 22, 2019
488
0
Thank you
Hi,

Try with this formula :
=IF(A2="mathura","plm",IF(AND(A2="agra",B2<=500),"pla","pl"))

Best regards