Question

[nikb_mt]

In cell A2 is 44 which represents how many hours I worked that week. 4 hours of that is OT. So I need a formula that will multiply anything over 40 by 18 to get my OT wage. Please help

 

[VoG]

What is your non-overtime rate?

 

[Jonmo1]

Try

=MAX(0,A2-40)*18

Hope that helps.

 

[nikb_mt]

12 is what I make without OT

 

[yogeshmaney]

If(a2>40,(a2-40)*18,0)

 

[Jonmo1]

To make the Rate variable as well...

Hours Worked in A2
Wage in A3

=MAX(0,A2-40)*(A3*1.5)

 

[nikb_mt]

=MAX(0,A2-40)*18 this worked
I don't understand how, but it worked

 

[VoG]

Maybe

Excel Workbook
	A	B
1	38	456
2	44	552
Sheet8

 

[Jonmo1]

=MAX(0,A2-40)*18 this worked
I don't understand how, but it worked

Max returns the largest of the referenced numbers.
The 2 referenced numbers are 0 and A2-40

If A2 is 40 or less, then A2-40 will be 0 or negative.
So 0 is larger than a negative number, right?
So max returns 0
0*18=0

If A2 is More than 40, then A2-40 = overtime hours.
Any positive number is larger than 0, so max returns that number
Then multiplied by 18


Hope that clears it up.