ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adding 150% to a cell (https://www.excelbanter.com/excel-discussion-misc-queries/12763-adding-150%25-cell.html)

Asta

adding 150% to a cell
 
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?

Asta

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?


RWN

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?





All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com