Hi!
It works for me, returns 0.
Biff
"M.A.Tyler" <Great Lakes State> wrote in message
news:65EE6FFF-9DBE-445B-83D3-B37E1A017F28@microsoft.com...
>I beleive that I've circled this one, and am close, but just can't seem to
> stumble onto the complete answer.
>
> A B C D E F
> 0 0 9 7 2 3
>
> A thru F are column headings the numbers below would represent the row.
> What
> I would like to do is this:
> =IF(OR(AND(E1>3,F1>4),OR(A1=9,B1=9,C1-D1>1)),0,50)
>
> In this instance the C1-D1 calculation in the "OR" area should make the
> answer true or here 0. It dosn't seem to work properly with regards to the
> A1
> and B1 problem. Any suggestions would be helpful!
Bookmarks