No. Most of these simple things are *easy* to find. Excel has a help
facility. If you don't know the syntax of the OR function, type the word OR
into Excel help. The same applies for any Excel function (except DATEDIF).
--
David Biddulph

"sm416" wrote in message
...
That did the trick. So simple, but the simple things are the hardest to
find!

thanks bpeltzer!

"bpeltzer" wrote:

The OR operator comes before the inputs: OR(A,B) rather than A OR B.
So to flag entries outside two standard deviations:
=IF(OR(N165(O165+2*P165),N165<(O165-2*P165)),"Flag","")

"sm416" wrote:

The formula I have requires a value to fall between an average plus or
minus
two times a standard deviation. The formula looks like this
=IF(N165O165+2*(P165)+OR(N165<O165-2*(P165)),"Flag","").
What I just discovered is that the "flag" will only appear when the
value is
greater than the ave + 2*standard diviation, not when it is less than
the
average minus 2*standard diviation. I would like to keep the formula
together so I do not have to add additional columns to the sheet. I
certainly could use some clarification to this formula. Each part
works as a
seperate formula but not together.

Thank you