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


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