Forum Discussion
NenaK
Dec 04, 2018Copper Contributor
What function to use if I want three seperate results depending on true, false and blank
Hello, I have two columns of data, if the two match I would like the result in the third column to be "QC OK', if they don't I would like the result to be "QC Fail", if the second column is left ...
Detlef_Lewin
Dec 04, 2018Silver Contributor
NenaK, choose CHOOSE(). :-)
=CHOOSE(COUNTIFS(A1:B1,B1)+1,"","QC Fail","QC OK")