IFERROR function returns 0 when there is an error. I would like to be able to provide value other than 0; for example, N/A, NO, or some other text string
You are missing the last parameter. Usage:
IFERROR(some_formula, return this instead if there is an error returned by some_formula)
Thomas K commented
Iferror already has a parameter for exactly that.