If condition
Closed
AMIT
-
Jan 9, 2016 at 05:11 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - Jan 9, 2016 at 05:47 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - Jan 9, 2016 at 05:47 AM
Related:
- If condition
- Conditional formatting if cell contains text ✓ - Excel Forum
- Nested if condition in excel - Guide
- Excel clear cell contents based on condition ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Conditional format range if one cell contains certain text - Excel Forum
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
February 14, 2026
491
Jan 9, 2016 at 05:47 AM
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
Try with this formula :
=IF(A2="mathura","plm",IF(AND(A2="agra",B2<=500),"pla","pl"))
Best regards
