if THIS & THAT, any way to do it

[amosslee]

I'm wanting to write a formula that checks two different criteria.

I need to say IF cell1=cell2 AND cell1not=0, then 1, else 0

Any help?

Thanks

[Domenic]

Try...

=IF((A1=A2)*(A1<>0),1,0)

Hope this helps!

I'm wanting to write a formula that checks two different criteria.

I need to say IF cell1=cell2 AND cell1not=0, then 1, else 0

Any help?

Thanks