Using "Verifiers"

[R.Best]

I have created what I call "Verifier" formulas in a large workbook to ensure
that my data, as well as my formulas are all acting in the way I intended, I
also use them to double check data entry.

I use "IF" formulas for all of my verifier cells. [=IF(A1=A2, "OK", "NOT OK")]
After the logical test the cell returns either ok, or not ok, using this
function with conditional formulas I can easily find errors in my
spreadsheets.

The problem that I'm running into is that I would like to have a master cell
at the top of each of my spreadsheets that can tell me if any of my verifier
cells are returning a certain text value (NOT OK).

I've tried using EXACT, LOOKUP, and some other formulas but keep running
into errors.

Does anyone know of a way to accomplish this?

(The cells are spread across the spread sheets and are in no particular
order.)

 

[Per Jessen]

Hi

You can use countif to count number of cells in a range which is not ok, and
if the result is above 0, then return 'Not OK'

=IF(COUNTIF(A1:G100,"Not ok")>0,"Not OK","OK")

Hopes this helps.
....
Per

 

[R.Best]

That works perfectly per, Thank you very much.

-Robert