Hello! I'm using Microsoft Excel 2004 for Mac. I am using it to calculate my payroll.

I have a cell that I need to calculate regular pay for the week (vs. overtime pay). So I need it to sum all hours for the week (which I do know how to do) but have the total never more than 40.00 (any excess hours will go in another cell, for overtime).

I don't know how to tell the formula that if the value of the sum is greater than 40, to still only show 40.

Is this possible? Can someone tell me how to do it?

Thank you!

=IF(SUM(A1:A2)>=40,40,SUM(A1:A2))

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History