Greetings.

I need to know if any of my formulas in a certain range have a value of 0 (zero). Range has multiple rows and columns.

I don't need conditional formatting on the cells themselves, I need this to appear in a separate area of the sheet, like a dashboard.

For instance:

Cell a1: new Formula with result of "Zero Exists" or "No Zeroes"

Range that might have zeroes: W20:AH40


I have used the search function but haven't seen anything that works for me.

Thanks for looking!!