IF conditional Help

[Bahaa]

I have rows and columns and need to insert the below in concept in formula

Columns are Major Minor and Insignificant
Rows are LIkely possible and Unlikely

=IF(AND(OR(H5="Likely",H5="Possible", H5="Unlikely"),AND(J5="Insignificant","Minor","Major ")),"X","")

If columns with a certain selection were equal to likely or possible or unlikely and at the same time rows were equal to insignificant or minor or major then insert x

Thanks in advance for all replies

 

[DanteAmor]

How about:

Book1
	G	H	I	J	K	L
4
5		likely		Minor	X
6
Sheet

Cell Formulas
Range	Formula
K5	K5	=IF(AND(OR(H5={"Likely","Possible","Unlikely"}),OR(J5={"Insignificant","Minor","Major "})),"X","")

 

[Bahaa]

How about:

Book1
	G	H	I	J	K	L
4
5		likely		Minor	X
6
Sheet

Cell Formulas
Range	Formula
K5	K5	=IF(AND(OR(H5={"Likely","Possible","Unlikely"}),OR(J5={"Insignificant","Minor","Major "})),"X","")

Many thanks Dante
The case here is that i have other cells as well that match same criteria but i need to make sure that exact cells contain certain text
if H5 = Likely or possible or unlikely but J5 contains exactly insignificant
and If H5= Unlikely and J5 exactly contains Minor
and If H5 = Unlikely and J5 exactly contains Major

Hope u get my point

 

[DanteAmor]

I think I have not understood.
But according to your last request, you need this:

=IF(AND(OR(H5={"Likely","Possible","Unlikely"}),J5="Insignificant"),"X",IF(AND(H5="Unlikely",OR(J5={"Minor","Major"})),"X",""))

If not, you could write all the combinations you need to validate.

 

[Bahaa]

IF(AND(OR(H5={"Likely","Possible","Unlikely"}),J5="Insignificant"),"X",IF(AND(H5="Unlikely",OR(J5={"Minor","Major"})),"X",""))

Many thanks but X is not showing in the cell

 

[DanteAmor]

What data do you have in H5 and what do you have in J5?

 

[Bahaa]

What data do you have in H5 and what do you have in J5?

In H5 i have Likley , Unlikely and Possible
In j5 i have Minor Major and Insignificant

 

[jasonb75]

You will want something like

=INDEX({"X","X","X";"X","X","";"X","",""},MATCH(H5,{"Likely","Possible","Unlikely"},0),MATCH(J5,{"Major","Minor","Insignificant"},0))

You may need to move the X's around slightly.

 

[Bahaa]

You will want something like

=INDEX({"X","X","X";"X","X","";"X","",""},MATCH(H5,{"Likely","Possible","Unlikely"},0),MATCH(J5,{"Major","Minor","Insignificant"},0))

You may need to move the X's around slightly.

Thanks Jason
But did not understand how i should move x
I have in H5 Column a list and i should choose either LIkely or Unlikely or Possible and in J5 a list where i should choose either Minor or Major or Insignificant
I need to make sure that when i select H5 Likely or Unlikely or Possible and J5 at the same time should be insignificant , then X should be placed in the K cell
And if i select J5 Minor or Major and H5 at the same time should be Unlikely then X should appear in K cell

I have this formula bit no results =IF(AND(OR(H5={"Likely","Possible","Unlikely"}),J5="Insignificant"),"X",IF(AND(H5="Unlikely",OR(J5={"Minor","Major"})),"X",""))

Thanks

 

[Bahaa]

You will want something like

=INDEX({"X","X","X";"X","X","";"X","",""},MATCH(H5,{"Likely","Possible","Unlikely"},0),MATCH(J5,{"Major","Minor","Insignificant"},0))

You may need to move the X's around slightly.