If condition

Closed

AMIT - Jan 9, 2016 at 05:11 AM
aquarelle Posts 7120 Registration date Saturday April 7, 2007 Status Anonymous Last seen April 14, 2023 - 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
What is optimal condition in phone - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel add row if condition met - Excel Forum
How to disable a cell in excel based on condition vba ✓ - Excel Forum

1 reply

Answer 1 / 1

aquarelle Posts 7120 Registration date Saturday April 7, 2007 Status Anonymous Last seen April 14, 2023 490
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

How to copy a data from one sheet to another, when specific criteria is met

Merge rows if it meets criteria in Excel

Highlight cell if another cell contains any text

Conditional format based on another cell containing text

Similar discussions

Subscribe To Our Newsletter!