software

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(E1gt;3,F1gt;4),OR(A1=9,B1=9,C1-D1gt;1)),0,50)

In this instance the C1-D1 calculation in the quot;ORquot; 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!

For one you can rewrite it as

=IF(OR(AND(E1gt;3,F1gt;4),A1=9,B1=9,C1-D1gt;1),0,50)

returns zero using your example, if you want something else post back

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
...
gt;I beleive that I've circled this one, and am close, but just can't seem to
gt; stumble onto the complete answer.
gt;
gt; A B C D E F
gt; 0 0 9 7 2 3
gt;
gt; A thru F are column headings the numbers below would represent the row.
gt; What
gt; I would like to do is this:
gt; =IF(OR(AND(E1gt;3,F1gt;4),OR(A1=9,B1=9,C1-D1gt;1)),0,50)
gt;
gt; In this instance the C1-D1 calculation in the quot;ORquot; area should make the
gt; answer true or here 0. It dosn't seem to work properly with regards to the
gt; A1
gt; and B1 problem. Any suggestions would be helpful!Hi!

It works for me, returns 0.

Biff

quot;M.A.Tylerquot; lt;Great Lakes Stategt; wrote in message
...
gt;I beleive that I've circled this one, and am close, but just can't seem to
gt; stumble onto the complete answer.
gt;
gt; A B C D E F
gt; 0 0 9 7 2 3
gt;
gt; A thru F are column headings the numbers below would represent the row.
gt; What
gt; I would like to do is this:
gt; =IF(OR(AND(E1gt;3,F1gt;4),OR(A1=9,B1=9,C1-D1gt;1)),0,50)
gt;
gt; In this instance the C1-D1 calculation in the quot;ORquot; area should make the
gt; answer true or here 0. It dosn't seem to work properly with regards to the
gt; A1
gt; and B1 problem. Any suggestions would be helpful!
Thanks for your help!

quot;M.A.Tylerquot; wrote:

gt; I beleive that I've circled this one, and am close, but just can't seem to
gt; stumble onto the complete answer.
gt;
gt; A B C D E F
gt; 0 0 9 7 2 3
gt;
gt; A thru F are column headings the numbers below would represent the row. What
gt; I would like to do is this:
gt; =IF(OR(AND(E1gt;3,F1gt;4),OR(A1=9,B1=9,C1-D1gt;1)),0,50)
gt;
gt; In this instance the C1-D1 calculation in the quot;ORquot; area should make the
gt; answer true or here 0. It dosn't seem to work properly with regards to the A1
gt; and B1 problem. Any suggestions would be helpful!