Issue with nested IF functions

[Red Dog]

Hi all,

Can someone explain to me what is going wrong with my formula below?

=IF((B2="Yellow"), (=IF(A2=B2), "AGREE", "DISAGREE"), "FALSE")

Basically, I have two columns of data. They both say either 'Yellow' or 'Blue'. Column A is one person and column B is another person. The column that this formula goes in basically wants to know whether person B is saying 'Yellow' and if so, does person A agree with person B?

Any help would be greatly appreciated.

[timiop2011]

I think this might be what you're looking for

Please Login or Register  to view this content.

It would return false if B2 did not say yellow. If B2 does say yellow it would say agree or disagree depending on what column A says.

[GC Excel]

Hello,

Try this formula :

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Red Dog]

Thanks everyone!

Much appreciated

[TMS]

You're welcome.