Hello,


Here is my formula:


=IF(AND(I2="c",M2=O2),TRUE,FALSE),IF(AND(I2="p",K2 =O2),TRUE,FALSE)


Rookie mistake I'm sure, however this is what i want it to do.


I2 has two values "C" or "P".


If I2 equals "C" i want it to also check if M2 is the same as O2(these two cells are words), if both are true I want a value of true



If I2 equals "P" I want it to also check if K2 is the same as O2(these two cells are words), and if both are true i also want a value of true.


if either of the criteria aren't met i want a return value of false.


Thanks in advance for any help .