IF, OR and SUM function

M

Machel

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
if true, if not nested if funcion 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
if function help 5
Average of difference between dates greater than zero 8
Multiple value if function using dates 2
sumif or sum production - 3 or more criteria 5
If Function 1

Top