have 2 if statements

[tlacloche]

hello,

i currently am using

Please Login or Register  to view this content.

i now want it to give a TRUE result if both A1=apple and B2=banana. if either one is not present, then its a FALSE.
they both need to be present for TRUE.

how do i edit the current formula


thanks

[Jonmo1]

Try

=AND(A1="apple", B2="banana")

[JieJenn]

=AND(A1="apple", B2="banana")

[vamosj]

Use the AND statement

[Pete_UK]

You can use this:

=AND(A1="apple",B2="banana")

Hope this helps.

Pete

[tlacloche]

thank you guys

[Jonmo1]

You're welcome.

[Pete_UK]

That's amazing !! Three identical solutions within a minute of each other, and within two minutes of the OP posing the question - I wonder just how close they were in seconds ?

Pete

[JieJenn]

I copied/pasted Jonmo1's answer.

[Pete_UK]

I copied/pasted Jonmo1's answer.

And changed the B1 to B2 ... <bg>

[Jonmo1]

I copied/pasted Jonmo1's answer.

And changed the B1 to B2 ... <bg>

I just copied JieJenn's.
Now we have a circular reference.