If problem

[rwhalls]

The formula below can produce two results. I need a third. If M17_R17 is greater than R17 the result should be 1.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Thanks

=IF(OR((M17+R17)=N17,(M17+R17)<N17),0,-1)<o></o>

 

[T. Valko]

The formula below can produce two results. I need a third. If M17-R17 is greater than R17 the result should be 1.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Thanks

=IF(OR((M17+R17)=N17,(M17+R17)<N17),0,-1)< font>

In its posted form Excel will not accept that as a formula.

If you make it syntactically correct, then the possible results are either M17+R17 or FALSE.

So, if you want to add another condition which of the conditions should take precedence? M17+R17=N17 or M17-R17 is greater than R17 ?

 

[rwhalls]

In the following formula when (M17+R17)<N17 it should produce -1. It produces 0.<N17 b 0.< a It -1. should produces produce it>
<N17 b 0.< a producing is It -1. be should><?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>


=IF(AND((M17+R17)<>N17,(M17+R17)>=N17),1,IF(OR((M17+R17)=N17,(M17+R17)<N17),0,-1)) <o></o>

 

[rwhalls]

In the following formula when (M17+R17)<N17 should be -1. It is producing a 0.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
=IF(AND((M17+R17)<>N17,(M17+R17)>=N17),1,IF(OR((M17+R17)=N17,(M17+R17)<N17),0,-1)) <o></o>