How to show message in Interactive excel table if results are null?

[C_J_M]

How to show message in Interactive excel table if results are null?

(I want to show the daily results of a google form in an interactive table, but if there are no results yet for that day, how can the interactive table say that there are no results yet for that day??)

Cheers 

[#2]

@C_J_M Assume your column A is dates including today date which is the day you want to get results, column B is results, then the cell where the message displays = IF(SUMIF(A1:A10,Today(),B1:B10)=0,"Results not yet available","")

If you do not need to show today date in the table and imply that results are for today, you can use = IF(COUNT(range/cell where today's results should be entered)=0,"not yet available","") if results are numbers/dates

or IF(COUNTA(range/cell where today's results should be entered)=0,"not yet available","")

[#3]

@hynguyen  Thanks a lot!

Afterall I made the formula a bit easier:

= IF(SUM(A2:A11)=0;"No reports yet today"; " ")

Cheers