More of an algebra question than an XL question.

40r + 5*1.5r = 1000
so
r(40 + 5*1.5) = 1000
r = 1000/(40 + 5*1.5)
r = 1000/47.5
r = 21.05
--
HTH...

Jim Thomlinson


"Susan" wrote:

I need to calculate hourly rate by a commission amount so I need to work
backwards. Gross pay of $1000 and 45 hours total worked. 5 of those hours
are overtime at time and half. I need to know what the actual hourly rate of
pay would be. I am not sure what function to begin with. Can anyone help
Thanks