Same question I added for Jim May's reply: Can we go one step farther, and
combine the two? Use of brackets, parentheses, etc. would be helpful in the
combined statement.

Thanks.
"pinmaster" wrote:


=IF(AND(conditions seperated by comas),if true,if false)
=IF(OR(conditions seperated by comas),if true,if false)

HTH
JG

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