IF Function

[carlos32202]

I need to write an IF function that will compare to see if T2>S2 AN
that S2 does NOT equal to zero (0). If it larger than S2 AND NOT EQUA
TO ZERO, then S2, if not T2.

Thank you

Confuse

 

[Peter Bernadyne]

Hi,

I think this should do it:

=IF(AND(T2>S2,T2<>0),S2,T2)

-Pet

 

[kkknie]

I'll give it a shot:

=IF(AND(T2>S2, S2<>0), S2, T2)


If T2>S2 And S2<> 0 Then S2, Else T2

 

[Frank Kabel]

Hi
=IF(AND(T2>S2,S2<>0),S2,T2)

If T2>= 0 in all cases you may also use
=MAX(S2,T2)

 

[Peter Bernadyne]

Ooops!

Please go with the other responses, mine was incorrect.

Apologies