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.

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Complete[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]No Cert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]Not Started[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]Not Compliant[/TD]
[/TR]
</tbody>[/TABLE]

 

[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