Ok, see if I got it now:

=IF(OR(AND(L1=0,LEN(B1)=0),AND(L1=5,LEN(B1)0)),"O K","Alert")

HTH,
Elkar


"Steve" wrote:

Perhaps if I start over. If L <5, and either or not text in B,
then either "alert" or "OK" in K
First row, nothing in B , D thru J adds up to zero , therefor need "OK" in K
2nd row, nothing in B , D thru J adds up to 7, therefore need "Alert" in K
3rd row, text in B, D thru J adds up to zero, therefore need "Alert" in K
last row, text in B, D thru J adds up to 5, therefore "OK" in K

B D E F G H I J K
L OK 0
1 1 1 1 1 1 1 alert 7
Sun/Mon alert 0
Sat/Sun 0 0 1 1 1 1 1 OK 5

Much thanks,

Steve