If condition

Closed
AMIT - Jan 9, 2016 at 05:11 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - 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

1 response

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jan 9, 2016 at 05:47 AM
Hi,

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

Best regards