On Dec 6, 11:07 am, "Search & You Will Find" <
jones.joh...@gmail.com>
wrote:
[snip previous]
> Thank you for this response. It worked PERFECTLY until there were days
> that individual a worked, but individual b didn't work. :-/
> I am trying to avoid a compound IF phrase that looks at each persons
> days off as that would become way to combersome of a formula. Any
> other ideas?
An extra column thrown in there will often allow you to avoid a huge
amount of complexity in an if( ) description. So the inner part of
some
huge complicated if( ) becomes a new column. Then the if( ) can
reference that column. It also gives you a chance to put a column
heading on, producing some extra documentation of what you are
doing. If well chosen, the extra column may help in other ways.
An other possible extra column use is something like total hours for
the day. You can maybe use that to simplify the if( ) formulas.
Socks