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

 

[Bahaa]

Hi @Bahaa,

The problem is that the "Risk Matrix" sheet has a space to the right of the words:
"Insignificant "
"Minor "
"Major "
Eliminate that space in words.
It also removes the space of those words in all formulas:

I attach the correct formulas:

To red:
=SI(O(Y(H5="Likely",J5="Minor"),Y(H5="Likely",J5="Major"),Y(H5="Possible",J5="Major")),"X","")

To yellow box cell N5
=SI(O(Y(H5="Likely",J5="Minor"),Y(H5="Posible",J5="Insignificant")),"X","")

To yellow box cell O6
=SI(Y(H5="Possible",J5="Major"),"X","")

To green box
=SI(O(Y(H5="UnLikely",J5="Insignificant"),Y(H5="Possible",J5="Insignificant"),Y(H5="UnLikely",J5="Minor")),"X","")

________________________________

I understand perfectly that it is forbidden to share files by mail, in fact I mentioned it in post #32, here I put the file so that everyone can see it.
The file:

Dropbox - File Deleted - Simplify your life

www.dropbox.com

________________________________

@Bahaa, Please, don't send files to my email in the future, I don't know how you got my email. You must put images here or copy ranges of cells and paste here.

Dante
It worked out
Buenos Dias and Muchas Gracias

 

[DanteAmor]

With xl2bb:

Book1
	N	O
5
6	X
سجل المخاطر

Cell Formulas
Range	Formula
N5	N5	=IF(OR(AND(H5="Likely",J5="Minor"),AND(H5="Posible",J5="Insignificant")),"X","")
O5	O5	=IF(OR(AND(H5="Likely",J5="Minor"),AND(H5="Likely",J5="Major"),AND(H5="Possible",J5="Major")),"X","")
N6	N6	=IF(OR(AND(H5="UnLikely",J5="Insignificant"),AND(H5="Possible",J5="Insignificant"),AND(H5="UnLikely",J5="Minor")),"X","")
O6	O6	=IF(AND(H5="Possible",J5="Major"),"X","")

 

[DanteAmor]

Dante
It worked out
Buenos Dias and Muchas Gracias

I'm glad to help you. Gracias por comentar ?

 

[jasonb75]

The problem is that the "Risk Matrix" sheet has a space to the right of the words:
"Insignificant "
"Minor "
"Major "

@Bahaa
I would just like to take this opportunity to point out that I rasied the issue of possible stray spaces way back in post #15, perhaps next time you will take the time to investigate such points when raised instead of repeatedly saying that perfectly good formulas are not working.

As is quite often the case, the fault lies with the source data, not with the formula.