IF / OR / Function 3 options

**Tyriel** · 07-15-2013, 01:34 PM

I have setup a IF OR function, but I need to put a third option on there and I am having trouble.

What I have currently. **A**
=IF(OR(D17=AB6,D17=AB7), "Target Change: ", "Current Target: ")

What I want to add (RED UNCERTAINTY) ***B***
=IF(OR(D17=AB6,D17=AB7,D17=AB8,) "Target Change: ", "Current Target: ", Suggested Target: ",)

The function works in **A**, but I am unsure how to get ***B*** to work & demonstrate what I would like to see.

Thanks for your help.

**etaf** · 07-15-2013, 01:43 PM

the function IF uses

if( test, true, false)
so IF
D17=AB6
OR
D17=AB7
is true then you get
"Target Change: "
otherwise its false and you get
"Current Target: "

Now you want to bring in a third option
OR(D17=AB6,D17=AB7,D17=AB8,)

D17=AB6
OR
D17=AB7
OR
D17=AB8
any are true - then you get
"Target Change:

So what are the next set of rules to work out if
"Current Target: "
OR
Suggested Target: "
should be used

does that help

you can use nested IFs

so
IF( TEST1, TRUE , IF(TEST2, TRUE, FALSE))

so if the result of test1 is false - you can then do another tests
or use true

IF( TEST1, IF(TEST2, TRUE, FALSE), FALSE))

**newdoverman** · 07-15-2013, 02:41 PM

Something like this will give the third option.

Formula:

Please Login or Register  to view this content.

This means that if all the cells are equal, that is the "Current Target: "

If only one cell is equal to D17 then "Target Change: "

If none of the cells equal D17 then "Suggest Target: "