View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim May
 
Posts: n/a
Default Create a formula using if, and, or or.

two samples..
=If(AND(b1=3,c15),"Both Coditions exist","Neither Condition exists")
=If(OR(b1=3,c15),"Both Coditions exist","Neither Condition exists")



"joanaww" wrote:

The courses I took didn't cover multiple conditional statements. Can someone
help me as to the proper syntax to write these? I need to do conditions of
"and" and "or", acting on one or more cells and different columns.

Thank you.