If Function - "and" command?

  • Thread starter Thread starter aronnov
  • Start date Start date
A

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
 
Aaron,

Try:

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

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top