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 .

Hi and welcome


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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Or

Hello,




Thank you very kindly for your responses. Problem has been solved.


Very helpful!!

Mark this thread as solved, you will find the button for this at the "thread tools" tab