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?
[TABLE="width: 507"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Coulmn B[/TD]
[TD]Coulmn C[/TD]
[TD]Coulnm D[/TD]
[TD]Coulmn E[/TD]
[/TR]
[TR]
[TD]id[/TD]
[TD]Validation[/TD]
[TD]Received date[/TD]
[TD]Received date<=assigned date[/TD]
[TD]Assigned date[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]Form[/TD]
[TD]13-05-2019[/TD]
[TD] [/TD]
[TD]16-05-2019[/TD]
[/TR]
[TR]
[TD]67676[/TD]
[TD]ID card[/TD]
[TD]13-05-2019[/TD]
[TD]FALSE[/TD]
[TD]12-05-2019[/TD]
[/TR]
[TR]
[TD]77888[/TD]
[TD]Badge[/TD]
[TD]13-05-2019[/TD]
[TD]FALSE[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 507"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Coulmn B[/TD]
[TD]Coulmn C[/TD]
[TD]Coulnm D[/TD]
[TD]Coulmn E[/TD]
[/TR]
[TR]
[TD]id[/TD]
[TD]Validation[/TD]
[TD]Received date[/TD]
[TD]Received date<=assigned date[/TD]
[TD]Assigned date[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]Form[/TD]
[TD]13-05-2019[/TD]
[TD] [/TD]
[TD]16-05-2019[/TD]
[/TR]
[TR]
[TD]67676[/TD]
[TD]ID card[/TD]
[TD]13-05-2019[/TD]
[TD]FALSE[/TD]
[TD]12-05-2019[/TD]
[/TR]
[TR]
[TD]77888[/TD]
[TD]Badge[/TD]
[TD]13-05-2019[/TD]
[TD]FALSE[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]