Syntax to "OR" 3 "ISERROR" conditions
=IF(OR(ISERROR(A1),ISERROR(B1),ISERROR(C1)),"",C1)
Regards,
Alan.
"Mike K" wrote in message
...
Oh Wise Ones,
I would like to filter the conditions of 3 columns
for
errors and evaluate in a fourth. I need a null value not just a white
font.
I've played with the OR syntax and nothing works. Any ideas please?
Basically I need in D1:
IF A1 OR B1 OR C1 is in error "" else C1.
Thanks,
Mike
|