| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif clarification | Excel Discussion (Misc queries) | |||
| Simple Question, display only part of a date in Number format | Excel Worksheet Functions | |||
| Beyond VLOOKUP Clarification | Excel Worksheet Functions | |||
| If function clarification | Excel Worksheet Functions | |||
| If and Dates Clarification | Excel Worksheet Functions | |||
Linear Mode
