Simple If, If part 2 (clarification)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Ok, see if I got it now:

=IF(OR(AND(L1=0,LEN(B1)=0),AND(L1=5,LEN(B1)>0)),"OK","Alert")

HTH,
Elkar
 
Hi

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

Arvi Laanemets
 
Back
Top