Please help
 

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.

Please help
 

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

" wrote:

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.

Please help
 

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


" wrote:

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.

Please help
 

On Feb 24, 2:51?am, Toppers wrote:
=IF(AND(AQ3=BI3,F3=BM3),1,0)



" wrote:
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.- Hide quoted text -

- Show quoted text -

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