exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi Team,
I have data like this and im using formula =IF(C3<=E3,"","FALSE") to get the result in column D. I want column D5 to display a message stating no data if date in E5 is blank rather than false. Could you help?
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I have data like this and im using formula =IF(C3<=E3,"","FALSE") to get the result in column D. I want column D5 to display a message stating no data if date in E5 is blank rather than false. Could you help?
| Column A | Coulmn B | Coulmn C | Coulnm D | Coulmn E |
| id | Validation | Received date | Received date<=assigned date | Assigned date |
| 12345 | Form | 13-05-2019 | 16-05-2019 | |
| 67676 | ID card | 13-05-2019 | FALSE | 12-05-2019 |
| 77888 | Badge | 13-05-2019 | FALSE |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
