IF, OR and SUM function
PERFECT! thank you
"T. Valko" wrote:
Try this...
=IF(OR(SUM(B9:H9)40,SUM(I9:O9)40),0,SUM(B9:O9))
--
Biff
Microsoft Excel MVP
"Machel" wrote in message
...
I am trying to make a function that looks at 2 weeks on a timecard and
flags
if one week sum is greater than 40. I can't get it entered correctly.
The
logic is:
If the sum of B9:H9 is greater than 40, OR the sum of I9:O9 is greater
than
40, put "0", otherwise put the sum of B9:O9.
I really appreciate your help!
|