|
But if I'm reading the formula correct what you have is doing this logic:
1. Is the value entered for each day Monday (B4) through Sunday (H4) greater than zero?
RESPONSE: FALSE, Sunday (H4) has a value of 0.
2. Then is the sum of hours from Monday (B5) through Saturday (G5) less than 40?
RESPONSE: FALSE, you have 8 hours in each of those six days which equals 48 hours.
Therefore: Value of H5 is zero.
Not sure again what you're trying to get to since if you flipped around the first false into a TRUE the result is also zero. And if you flipped around the second false into a TRUE you'd get the least of 8, -8, and 0, which would be -8.
|