View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Machel Machel is offline
external usenet poster
 
Posts: 9
Default IF, OR and SUM function

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!