mart_mrexcel
Active Member
- Joined
- Aug 23, 2008
- Messages
- 302
- Office Version
- 365
- Platform
- Windows
I was trying to put an indicator message as "Product Expired with No Date▼" in the above heading of date with 2 criteria, that is Expired as "Yes" and Date is blank, using the below formula and it does not work. In below, the message indicator should appear since Prd-001 is Yes and the date if blank.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | =IF(AND(COUNTIF(B3:B5,"="&"Yes"),isblank(C3:C5)),"Product Expired with No Date▼","") | ||||
| 2 | Product Code | Expired? | Date | ||
| 3 | Prd-001 | Yes | |||
| 4 | Prd-002 | ||||
| 5 | Prd-003 | Yes | January 30, 2024 |
