Please help

[cstephens79]

I am trying to write an argument that states if aq3=bi3 and f3=bm3. if
true return a 1 if false return a 0. Everytime i try to write it i get
an error, cell aq3 has a formula in it but i dont think it would cause
this problem.

 

[Toppers]

=IF(AND(AQ3=BI3,F3=BM3),1,0)

 

[Teethless mama]

=AND(AQ3=BI3,F3=BM3)*1

 

[Kris79]

=IF(AND(AQ3=BI3,F3=BM3),1,0)





- Show quoted text -

Thank you for your help, i see where i was going wrong.