I have created a payroll which i need to create and i've got most set up.
i need to know how i can take D2 times it by 150% from E2 and give me the
result to G2.

Ok to say it simpler
Overtime hours is in D2. Normal hourly rate is in E2 and overtime earned is
in G2
overtime payment is at the rate of 150% of the normal hourly rate. How can i
create such a formula to give the results in G2?

At the moment i've got it like this:
=SUMPRODUCT(D2)*(E2*150%)
which worked fine but i was thinking if this is overkill in how to do it?

"Asta" wrote:

I have created a payroll which i need to create and i've got most set up.
i need to know how i can take D2 times it by 150% from E2 and give me the
result to G2.

Ok to say it simpler
Overtime hours is in D2. Normal hourly rate is in E2 and overtime earned is
in G2
overtime payment is at the rate of 150% of the normal hourly rate. How can i
create such a formula to give the results in G2?

In G2;
D2*E2*1.5

--
Regards;
Rob
------------------------------------------------------------------------
"Asta" wrote in message
...
At the moment i've got it like this:
=SUMPRODUCT(D2)*(E2*150%)
which worked fine but i was thinking if this is overkill in how to do it?

"Asta" wrote:

I have created a payroll which i need to create and i've got most set up.
i need to know how i can take D2 times it by 150% from E2 and give me the
result to G2.

Ok to say it simpler
Overtime hours is in D2. Normal hourly rate is in E2 and overtime earned is
in G2
overtime payment is at the rate of 150% of the normal hourly rate. How can i
create such a formula to give the results in G2?