Help With a Formula

[OdysseusVII]

I'm not sure if this is even possible but I'm trying to populate a series of different answers depending on the value of previous cells. The different formulas are below, but I would need any given cell in the 5th column to be able to return any of these four answers based on the previous 4 cells. Right now we are populating the 5th column manually and it is hugely time consuming.

I really appreciate any help you may be able to provide.

1	#N/A	1	1	Complete
1	#N/A	#N/A	#N/A	No Cert
#N/A	#N/A	#N/A	#N/A	Not Started
1	#N/A	1	#N/A	Not Compliant

<tbody>
</tbody>

 

[XOR LX]

Hi,

You don't actually give the criteria, though I presume it's based on the number of 1s in a given row:

=INDEX({"Not Started";"No Cert";"Not Compliant";"Complete"},1+COUNTIF(A1:D1,1))

You also don't mention what should be the result if all four cells contain 1s, so I presume this is not a possibility.

Regards