Absence Management

Absence Management

Suppose you are the owner of a small business. You have several employees. Each one of them has a “standard” amount of hours for each working day.

At the end of the day you want to know:

*which employees worked less than the “standard”

*which employees exceeded the “standard”

*which employees worked the exact amount of “standard” hours.

So, the most obvious function you’d think of, off the top of your head, would be the IF function:

 

                   Pic. No 1: The IF solution (not so good..)

 

However, a much simpler solution would be this one, without IF:

                  Pic. No 2: A better solution