If Function - "and" command?

[aronnov]

I have a basic If Function, (see below) Is there anyway I can add a 'and'
command? So it could read: =IF(B3=B16 and B16 does not equal to 0,1,0)

how can I add 'and B16 does not equal to 0'?

=IF(B3=B16,1,0)

Aaron

 

[Sandy Mann]

Aaron,

Try:

=IF(AND(B3=B16,B16<>0),1,0)

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk