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 blank I would like the result in the third column to be left blank. The IF function only allows two results. What function would I use so I can get the third?
Thank you.
- Detlef_LewinSilver Contributor
NenaK, choose CHOOSE(). :-)
=CHOOSE(COUNTIFS(A1:B1,B1)+1,"","QC Fail","QC OK")