B
Brittany.hogan
I need to know how to calculate gross payment using the if function and
calculate it with overtime if logic is false
calculate it with overtime if logic is false
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Brittany.hogan said:I need to know how to calculate gross payment using the if function and
calculate it with overtime if logic is false
Since there are innumerable ways to calculate "gross payment", depending
on circumstances, along with innumerable ways of calculating overtime,
perhaps if you gave the rules for calculation, as well as some examples,
it would help us to answer your question...
B
Brittany.hogan
I have a fixed cell like b3>=$a$4 which is x hours greater than 40 you need
to multiply b3 by b2 which is the hourly rate and then the remaining hours by
1.5 for time and half then add them together and get your answer from the if
function
to multiply b3 by b2 which is the hourly rate and then the remaining hours by
1.5 for time and half then add them together and get your answer from the if
function
J
JE McGimpsey
Brittany.hogan said:I have a fixed cell like b3>=$a$4 which is x hours greater than 40 you need
to multiply b3 by b2 which is the hourly rate and then the remaining hours by
1.5 for time and half then add them together and get your answer from the if
function
I can't tell what role $A$4 plays or what IF function you're referring
to, but one way to calculate total payment:
B2: <hourly rate>
B3: <hours>
B4: =B2 * (B3 + 0.5 * MAX(B3-40,0))