jeudi 17 mai 2018

=If(and( is Not working

enter image description here

Hi all,

Im struggling with an IF(And formular, I have so far attempted the following two formulars.

IF(AND(($J5="TRUE"),SEARCH("Diff",$K5)),"Change","No Change")

IF(AND((L6="TRUE"),(M6="Different")),"Change", "No Change")

I have tried the above but all I seem to get in is No Change coming up even though the criteria has been met.

Can anyone suggest a solution?

Many Thanks Joe

Aucun commentaire:

Enregistrer un commentaire