I have an overtime calculation issue that is not working out well at all..
I need to have a column add up to, but not exceed 44. is this possible?
12 12
12 12
12 12
12 8
12 0
12 0
12 0
or
0 0
12 12
8 8
12 12
12 12
12 0
12 0
12 0
I have an overtime calculation issue that is not working out well at all..
I need to have a column add up to, but not exceed 44. is this possible?
12 12
12 12
12 12
12 8
12 0
12 0
12 0
or
0 0
12 12
8 8
12 12
12 12
12 0
12 0
12 0
Not sure what that would achieve that =MIN(column_total, 44) wouldn't. So, for column B, for example:Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks