Using "Verifiers"

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.)

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" skrev i meddelelsen
...
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.)

That works perfectly per, Thank you very much.

-Robert