adding 150% to a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

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

Back
Top