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

if true, if not nested if funcion 2
Multiple logic tests 0
if function help 5
Multiple value if function using dates 2
Function for a nested if statement 2
If/Then functions in Excel 1
If Function 1
sumif or sum production - 3 or more criteria 5

Top