| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return 1 of 3 different values based on multiple cells
Need Formula or macro to allocate the "Scheduled hours" based on Group Counts:
If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C" should both be 6 hours If Group "A" and "C" are equal to or less than 0, then Scheduled "A" and "C" should both be 0 hours If Group "A" greater than 1, and Group "C" is equal to 0, then Scheduled "A" should 12 hours If Group "C" greater than 1, and Group "A" is equal to 0, then Scheduled "C" should 12 hours What should be returned for Scheduled Hours Group Count Scheduled Hours A B A B 1047 1192 6 6 0 995 0 12 1752 0 12 0 0 0 0 0 0 0 0 0 -- Thanks - Suze |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return 1 of 3 different values based on multiple cells
Answered in the 'Worksheet Functions' forum
-- Gary Brown "Susan in Sacramento" wrote: Need Formula or macro to allocate the "Scheduled hours" based on Group Counts: If Group "A" and "C" are both greater than 1, then Scheduled "A" and "C" should both be 6 hours If Group "A" and "C" are equal to or less than 0, then Scheduled "A" and "C" should both be 0 hours If Group "A" greater than 1, and Group "C" is equal to 0, then Scheduled "A" should 12 hours If Group "C" greater than 1, and Group "A" is equal to 0, then Scheduled "C" should 12 hours What should be returned for Scheduled Hours Group Count Scheduled Hours A B A B 1047 1192 6 6 0 995 0 12 1752 0 12 0 0 0 0 0 0 0 0 0 -- Thanks - Suze |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cells to look up and return values to another spreadsheet | Excel Worksheet Functions | |||
| select value in table based on values entered in multiple cells | Excel Worksheet Functions | |||
| Return specific values based on multiple crireria | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| Adding multiple cells, return specific values | Excel Worksheet Functions | |||
Hybrid Mode
