3 components into one formula

[witt1989]

I have several columns of data that I need to figure a formula for

Anything that equals 0 is 100% compliant anything 1-4 is partial compliant and anything =5 or greater is 0% compliant.

[DonkeyOte]

witt1989, not much to go on there... perhaps

=LOOKUP(value,{0,1,5},{"100% Compliant","Partial Compliant","0% Compliant"})

[martindwilson]

=IF(A1=0,"100% compliant",IF(AND(A1>0,A1<5),"partialy compliant","0% compliant"))