In general terms:
=IF(AND(X=?,OR(Y=?,Z=?)),?,"")
This formula would have to be in cell Q

An example with actual cells:
=IF(AND(A1=10,OR(A2=15,A3=20)),100,"")
This formula must be in the cell to which the result should be returned. A
formula can't "reach out" and put a value in another cell; it just returns a
value to the cell that has the formula.

Please note that a formula can return an empty string "" which makes it
appear empty, but it is not actually blank (it contains the formula).

Hope this helps,

Hutch

"Paul" wrote:

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