Formula Help

[jamessharpe]

Hi All,
I currently have a formula to show if cell I3 shows the mentioned values that it will input Key Player into cell J3,

=IF(OR(I3="6-6",I3="6-7",I3="6-8",I3="6-9",I3="7-6",I3="7-7",I3="7-8",I3="7-9",I3="8-6",I3="8-7",I3="8-8",I3="8-9",I3="9-6",I3="9-7",I3="9-8",I3="9-9"),"Key Player","")

how do I do this so there are 4 outcomes for the different sets, please don't waste your own time inputting all the data and if possible give me the formula minus the data

IF I3 equals 6-6/6-7/6-8/6-9/7-6/7-7/7-8/7-9/8-6/8-7/8-8/8-9/9-6/9-7/9-8/9-9 I want it to insert Key player
IF I3 equals 6-1/6-2/6-3/6-4/7-1/7-2/7-3/7-4/8-1/8-2/8-3/8-4/9-1/9-2/9-3/9-4 I want it to insert Keep informed
IF I3 equals 1-6/1-7/1-8/1-9/2-6/2-7/2-8/2-9/3-6/3-7/3-8/3-9/4-6/4-7/4-8/4-9 I want it to insert Keep satisfied
IF I3 equals 1-1/1-2/1-3/1-4/2-1/2-2/2-3/2-4/3-1/3-2/3-3/3-4/4-1/4-2/4-3/4-4 I want it to insert Monitor

thanks in advance

 

[AlanY]

Hi All,
I currently have a formula to show if cell I3 shows the mentioned values that it will input Key Player into cell J3,

=IF(OR(I3="6-6",I3="6-7",I3="6-8",I3="6-9",I3="7-6",I3="7-7",I3="7-8",I3="7-9",I3="8-6",I3="8-7",I3="8-8",I3="8-9",I3="9-6",I3="9-7",I3="9-8",I3="9-9"),"Key Player","")

how do I do this so there are 4 outcomes for the different sets, please don't waste your own time inputting all the data and if possible give me the formula minus the data

IF I3 equals 6-6/6-7/6-8/6-9/7-6/7-7/7-8/7-9/8-6/8-7/8-8/8-9/9-6/9-7/9-8/9-9 I want it to insert Key player
IF I3 equals 6-1/6-2/6-3/6-4/7-1/7-2/7-3/7-4/8-1/8-2/8-3/8-4/9-1/9-2/9-3/9-4 I want it to insert Keep informed
IF I3 equals 1-6/1-7/1-8/1-9/2-6/2-7/2-8/2-9/3-6/3-7/3-8/3-9/4-6/4-7/4-8/4-9 I want it to insert Keep satisfied
IF I3 equals 1-1/1-2/1-3/1-4/2-1/2-2/2-3/2-4/3-1/3-2/3-3/3-4/4-1/4-2/4-3/4-4 I want it to insert Monitor

thanks in advance

insert your second IF into the first "",
3rd IF inti the second "", etc

so your full formula should looks like

=IF(OR(I3="6-6",I3="6-7",I3="6-8",I3="6-9",I3="7-6",I3="7-7",I3="7-8",I3="7-9",I3="8-6",I3="8-7",I3="8-8",I3="8-9",I3="9-6",I3="9-7",I3="9-8",I3="9-9"),"Key Player","IF I3 equals 6-1/6-2/6-3/6-4/7-1/7-2/7-3/7-4/8-1/8-2/8-3/8-4/9-1/9-2/9-3/9-4","Keep informed",IF I3 equals 1-6/1-7/1-8/1-9/2-6/2-7/2-8/2-9/3-6/3-7/3-8/3-9/4-6/4-7/4-8/4-9,"Keep satisfied","Monitor"))))

 

[Ramballah]

just extend ur if formula, u got "Key player" for if its true then u got "" if its false. Meaning if u put the next if formula on the place if it isnt true it will look for that. so u can continue, ull get a hella long formula XD
so it will be if=i3=this and this and that or this bla bla THEN keyplayer, if its not then IF=I3=THIS BLA THIS and stuff then u put keep informed if its not u go to the next one

 

[Fluff]

Something like
=IF(OR(I3={"6-6","6-7","6-8","6-9","7-6","7-7","7-8","7-9","8-6","8-7","8-8","8-9","9-6","9-7","9-8","9-9"}),"Key Player",if(or(i3={…}),"Keep Informed"))

 

[jamessharpe]

Thank you to all of you this worked perfect, this has been wrecking my head for 2 days and it was so simple! I really appreciate it.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[jtakw]

Hi,

See if this significantly simplified version works for you:

Book1
	I	J
3	6-6	Key player
4	6-1	Keep informed
5	1-6	Keep satisfied
6	1-1	Monitor
Sheet501

Cell Formulas
Range	Formula
J3	=IF(LEFT(I3)+0>=6,IF(RIGHT(I3)+0>=6,"Key player","Keep informed"),IF(RIGHT(I3)+0>=6,"Keep satisfied","Monitor"))