if two cells = true then true

[BigTandthepc]

Hi Everyone,

I need an If formula for matching that both cells = True

so it needs to be: If A1 & B1 = True then true if not faulse

I no i'm almost there but cant quiet get it!

help me please!!!

[Pete_UK]

Try this:

=AND(A1,B1)

Hope this helps.

Pete

[BigTandthepc]

Hi I did what i though you meant but it didn't work what have i done wrong?

=IF(AND(W5,X5)="true",1,0)

[Pete_UK]

You have put true in quotes, which turn it into a text value. Try this:

=IF(AND(W5,X5)=TRUE,1,0)

or this, as TRUE is implied:

=IF(AND(W5,X5),1,0)

or this, based on my earlier suggestion to return 1 or 0:

=--AND(W5,X5)

or this to do the same thing:

=AND(W5,X5)*1

Hope this helps.

Pete

[BigTandthepc]

You Are Brilliant!

Thank you so much!

Perfect! (First one exactly what I needed!)

I new I was close but thanks so much

[Pete_UK]

Glad to be of help, but all four of those suggestions will give you the desired result (with less typing for the last two).

Pete