Excel Question #46

Alex · 02-16-2012, 03:11 PM

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.

02-16-2012, 03:11 PM	#1
Alex . Join Date: Feb 2005 Posts: 13,354	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.
	Submit to Quotes