Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi. I need to be able to figure out the number of working days per month
based on 17 individual work calendars. I have used Chip Pearson's workaround for more than 7 nested ifs and it works great. Problem is I have three named formula and when I do a nested if using the names, it doesn't work. Works fine if I only use two named fomula. Anyone have any ideas? Oh, the boss doesn't want me to use code -- just formulas. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
Help with formula too many nested IFs | Excel Worksheet Functions | |||
Nested Formula? | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
UPDATED - Referencing named Ranges within a Nested IF formula | Excel Worksheet Functions |