More logical test in IF statement

[tony wong]

How can i set up one more logical test

=IF(B3>=$C$2, B3, 0)

My condition is B3>=C2 and B3<20000

Thanks a lot.

 

[Andy B]

Hi

Try this:
=IF(AND(B3>=$C$2,B3<20000),B3,0)

Hope this helps.

 

[tony wong]

Thanks Andy

Hi

Try this:
=IF(AND(B3>=$C$2,B3<20000),B3,0)

Hope this helps.