If logical test

[bmarroush]

Could you please help over this formula where I need to have separate logical test where if two certain cells contains special text like medium or high an x should be replaced in other certain cell

formula is like but not working

=IF(AND(H128="High",G128="Medium",H128="Medium",G128="High")=TRUE,"X"," ")

 

[Aladin Akyurek]

Try...

=IF(AND(OR(H128="high",H128="medium"),OR(G128="high",G128="medium")),"X","")

 

[sericom]

Not exactly sure of your logic requirements, but try

=IF(OR(H128="High",G128="Medium",H128="Medium",G128="High"),"X"," ")

 

[joeu2004]

formula is like but not working
=IF(AND(H128="High",G128="Medium",H128="Medium",G128="High")=TRUE,"X"," ")

And yet another possible interpretation, absent a complete and accurate explanation of your intent:

=IF(OR(AND(H128="High",G128="Medium"),AND(H128="Medium",G128="High")), "X", "")

That returns "X" only if "high" in H128 is paired with "medium" in G128 or vice versa.

Note the use of the null string ("") instead of a space (" "). The null string is preferred because it allows for simple dependent formulas like IF(K128="",....), which probably works as intended whether K128 is empty or it contains a formula that returns the null string.