If condition

Closed

AMIT - Jan 9, 2016 at 05:11 AM
aquarelle Posts 5961 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - 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

If condition
Excel clear cell contents based on condition ✓ - Excel Forum
Excel conditional formatting if cell contains specific text ✓ - Excel Forum
If cell contains text then return value multiple conditions ✓ - Excel Forum
Excel copy cell if condition met - Excel Forum
Excel if condition color cell - Guide

1 response

Answer 1 / 1

aquarelle Posts 5961 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 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

Similar discussions

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

Copy rows based on a condition

Copy rows to new sheets if condition is met

Similar discussions

Subscribe To Our Newsletter!