Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |