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.
|