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

If condition
Available memory less than 15mb condition zero - Guide
If condition in excel - Guide
Conditional formatting if two cells match ✓ - Excel Forum
Vba copy data from one sheet to another if a condition is met - Excel Forum
Your phone is optimal condition meaning - Guide

1 response

Answer 1 / 1

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

Similar discussions

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

Merge rows if it meets criteria in Excel

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!