IF #N/A ( in a range), "ALERT","OK"
Thank you,
Works great. And so simple too.
Thanks again,
Steve
"T. Valko" wrote:
Try this:
=IF(COUNTIF(E4:E631,"#N/A"),"ALERT","OK")
--
Biff
Microsoft Excel MVP
"Steve" wrote in message
...
I have a rang of cells with formulas in them as below:
=VLOOKUP(Data!A4,Table!$A$1:$A$101,1,FALSE).
This formula produces either numbers or #N/As in the below range:
The range is from E4 through E631.
If any of the cells ( E4:E631) have #N/A in them, I would like "ALERT" to
show Cell G2, if no #N/A, then "OK" in cell G2.
Something like If (E4:E62 contains #N/A, "Alert", "OK")
So I don't have to scroll down looking for #N/A 's that may or may not be
there.
Thanks,
Steve
|