If condition

Closed

AMIT - Jan 9, 2016 at 05:11 AM
aquarelle Posts 5959 Registration date Saturday April 7, 2007 Status Moderator Last seen February 9, 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
Add if condition in excel - Guide
Excel if condition color cell - Guide
Excel copy row if condition met ✓ - Excel Forum
If cell contains date then conditional format - Guide
If cell contains text then return value multiple conditions ✓ - Excel Forum

1 response

Answer 1 / 1

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

Clear cell contents based on value of another cell range using VBA

Copying cells if condition is met

Similar discussions

Subscribe To Our Newsletter!