View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Syntax to "OR" 3 "ISERROR" conditions

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