If OR Calculation

[D Willett]

Hi

I have 4 columns all containing hours. If any of the cells contain less than 40 I need a penalty.

Week 1 = C2
Week 2 = H2
Week 3 = M2
Week 4 = R2

=If C2<40, or H2<40, or M2<40, or R2<40 Then X2 = (TRUE PART)B2 * Total Hours, (FALSE PART)F2+K2+P2+U2

The formula should look to see if any of C2",H2,M2,R2 are less than 40. if so return the TRUE PART else return the FALSE PART

I'm not sure of the syntax.

Cheers

[HansV]

How about

=IF(MIN(C2,H2,M2,R2)<40,B2*SUM(C2,H2,M2,R2),SUM(F2,K2,P2,U2))

[D Willett]

Nearly Hans.

The formula should look at C2 H2 M2 R2, and if any of them contain less than 40 (Not the total of all) then return the TRUE PART, esle FALSE PART.

So I could have C2=39, H2=60 M2=58, R2=51 Because C2<40 return TRUE PART

[HansV]

Have you tried it?

[D Willett]

Sorry Hans, you were correct... It works fine...

Thanks again for the support

[HansV]

If any of the hours is less than 40, the minimum will be less than 40 and vice versa...