#1
|
|||
|
|||
if function Help
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 . |
#2
|
||||
|
||||
Hi and welcome
try =IF(OR(AND(I2="p",K2 =O2),AND(I2="c",M2=O2)),TRUE,FALSE)
__________________
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 |
#3
|
|||
|
|||
Or
Code:
=OR(AND($I2="C",$M2=$O2,$O2<> ""),AND($I2="P",$K2=$O2,$O2<>"")) |
#4
|
|||
|
|||
Hello,
Thank you very kindly for your responses. Problem has been solved. Very helpful!! |
#5
|
||||
|
||||
Quote:
Mark this thread as solved, you will find the button for this at the "thread tools" tab |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
#REF! Error in calling VBA function disappears when function is copied | lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
how to use now() function | gsrikanth | Excel | 1 | 01-07-2012 01:18 AM |
if function help | jim831 | Excel | 2 | 10-29-2010 07:06 PM |