Calculating error with if

[andrewb90]

Hello All,

I put together this formula that is supposed to be calculating overtime and it works if the hours exceed 40 but not less than 40. Can anybody assist me with this?

=(IF(S91>40,40*T91,S91*T91))+(IF(S91>40,((S91-40)*U91),""))

S column is hours worked
T column is regular pay rate
U column is overtime pay rate

 

[LrnItAll]

=(IF(S91>40,40*T91,S91*T91))+(IF(S91>40,((S91-40)*U91),0))

it is trying to add a number to "" and is resulting in an error. I think that is what is causing you issues. Change the "" to 0.

 

[jtakw]

Hi,

I think your formula should be:

=IF(S91>40,40*T91+(S91-40)*U91,S91*T91)

 

[andrewb90]

Perfect thank you!

 

[jtakw]

You're welcome, thanks for the feedback.