If condition [Closed]

Report
-
Posts
7073
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 24, 2020
-
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

1 reply

Posts
7073
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 24, 2020
498
Hi,

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

Best regards