Excel alert formula if cells in certain area are empty

[herukuncahyono]

Hello,

I want to know what formula can be used to give a warning if in a certain area there are empty cells

For example, the word "Beware" will appear in cell D1 if 1 cell or more cells in the area A1:B10 is empty.

Regards

[Estevaoba]

Maybe:
=IF(COUNTBLANK(A1:B10),"Beware","")
Or:
=IF(COUNTIF(A1:B10,""),"Beware","")

Good luck!

[herukuncahyono]

Hi Estevaoba,

Thanks for the help I really appreciate it, problem solved!

Regards

[Estevaoba]

You're welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day!