How to calculate gross payment

[Brittany.hogan]

I need to know how to calculate gross payment using the if function and
calculate it with overtime if logic is false

 

[JE McGimpsey]

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...

 

[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

 

[JE McGimpsey]

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))