View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=IF(AND(A1="x",C1="x",E1="x"),"yes","no")

--

Regards,

Peo Sjoblom


"alm09" wrote in message
...
Is it possible to have an "AND" condition in an "If Then" statement?

For example, how would you write "if cell A1 and C1 and E1 all equal "x",
then return "yes". If not, return "no".