Simple If, If part 2 (clarification)
 

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

Simple If, If part 2 (clarification)
 

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

Simple If, If part 2 (clarification)
 

Hi

Something like this?
=IF((B2="")+(SUM(D2:J2)=0)=1,"Alert","OK")

Arvi Laanemets


"Steve" wrote in message
...
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

Simple If, If part 2 (clarification)
 

Both Elkar's and Arvi's solutions worked great.
Thank you both so much.

Steve

"Elkar" wrote:

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