View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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