Excel Formula for cell with maximum value

Microsoft / Excel
July 27, 2009 at 10:51:01
Specs: Macintosh

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!

See More: Excel Formula for cell with maximum value

Report •

July 27, 2009 at 10:56:09

Report •
Related Solutions

Ask Question