Forum Discussion

NenaK's avatar
NenaK
Copper Contributor
Dec 04, 2018

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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    NenaK, choose CHOOSE(). :-)

     

    =CHOOSE(COUNTIFS(A1:B1,B1)+1,"","QC Fail","QC OK")

     

Resources