Using "Verifiers"

  • Thread starter Thread starter R.Best
  • Start date Start date
R

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