This may sound like a sophmoroic question, but I have couple of books on
Excel 2007. Microsoft's "Excel 2007, Inside Out", and John Walkenbach's
"Excel 2007 Formulas".

After reading and applying the "MAX" function that was posted here (Thank
you again!), I started looking up this function in both of theses books
(which I did reference, in vain, in the first place), and, maybe it's me
(and I'm sure it is), but from the description in these books, I still have
NO IDEA how this function applys in this instance.

Can anyone recommend some reference source that spells these things out so
that a newb like myself might understand it?

Thanks Again,

Mike

"Michael Slater" wrote in message
...
I have a column that shows employees working on a given day. The bottom
cell of that column "total"s the number of employees working.

I would like to have the cell below the "total" cell, which would be
"overtime shifts available", increase by "1" for each decrease in the
"total" cell, above, when it goes below "6".

So, if the "Total" cell is "5", the "Overtime" cell is "1".
If the "Total" cell is "4", the "Overtime" cell is "2", etc...

Using an "IF" formula, I've gotten it to indicate "1" when the "Total"
cell is "5", but I'm lost after that.

Any help appreciated.

Mike