View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=if(or(d1=e1,d1=e2),"X","")

"ellebelle" wrote in message
...
I want a function in cell A1 that writes 'X' if cell D1 equals the value in
either cell E1 or E2.