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

Using "Verifiers"
 

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

Using "Verifiers"
 

That works perfectly per, Thank you very much.

-Robert