Calculate pay only up to 40 hours

[soggycashew]

Hello, I have amount employee makes in C5 and hours worked in D5. I need an if statement to calulate the amount the employee made up to 40 hours only.

Thanks

 

[soggycashew]

I answered my own question thanks.... Please delete post admin!

 

[PaddyD]

Better option - post your solution so if someone with a similar problem stumbles on your thread they can use it...