View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default IF OR Statements

Example formula:

=IF(AND(A1=2,OR(A2=3,A3=3)),TRUE,FALSE)

The OR and AND function contain their arguements.
--
Best Regards,

Luke M
"Paul" wrote in message
...
Anybody know how to write a formula for a statement involving "if" and
"or"
statements such as:

if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank