=IF help

[CrazyCanuck]

I am using this formula so that if these 2 cells are equal I get 1 if not I get 0. But I don't want the 1 to show if cells B2 and D2 are empty. What can I add to my formula to have empty cells not appear as equal?


=IF(B2=D2,"1","")

 

[dreid1011]

Maybe this:

=IF(AND(B2=D2,B2<>"",D2<>""),"1","")

 

[CrazyCanuck]

Maybe this:

=IF(AND(B2=D2,B2<>"",D2<>""),"1","")

Yes that was it thanks a bunch!

 

[dreid1011]

You're welcome, happy to help.

 

[Peter_SSs]

Maybe this:

=IF(AND(B2=D2,B2<>"",D2<>""),"1","")

A relatively minor thing but surely not so may checks are required. I would also be surprised if the 1 needs to be in quote marks.

=IF(AND(B2=D2,B2<>""),1,"")