if with 2 conditions

[vano]

Hi All,
How can I create an if statement with 2 conditions?
Eg.
=IF(M32=LARGE(M32:U32,1) *and M32>0*,system1!C33,0)

I am not sure how to but 2 conditions in.
I can get it to work with out and m32>0.

Thanks in advance,

Va

 

[duane]

=if(and(M32=LARGE(M32:U32,1),M32>0),system1!C33,0

 

[RagDyer]

Try this:

=IF(AND(M32=LARGE(M32:U32,1), M32>0),system1!C33,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi All,
How can I create an if statement with 2 conditions?
Eg.
=IF(M32=LARGE(M32:U32,1) *and M32>0*,system1!C33,0)

I am not sure how to but 2 conditions in.
I can get it to work with out and m32>0.

Thanks in advance,

Van