Hi all,
Im trying to use an IF formula to calculate an out put in dollars.
The formula is supposed to have a total number of hours that is a sum of hours worked and deduct the overtime trigger of 65 hours. The result is then muliplied by a dollar amount to give overtime dollars earned. The fomular I have is:
=IF(D35>(65/24), ((D35-(65/24)*120)), 0)
The result should be 126 but the answer I get is $-322.25.
Please, any suggestions as to what I'm doing wrong.
Im trying to use an IF formula to calculate an out put in dollars.
The formula is supposed to have a total number of hours that is a sum of hours worked and deduct the overtime trigger of 65 hours. The result is then muliplied by a dollar amount to give overtime dollars earned. The fomular I have is:
=IF(D35>(65/24), ((D35-(65/24)*120)), 0)
The result should be 126 but the answer I get is $-322.25.
Please, any suggestions as to what I'm doing wrong.