problem with formula using max

[jonathanhili94]

Can anyone help please? For some reason the highlighted tab is shown 174 but I want that the number on this cell does not exceed the 173.33, so he maximum number will be 173.33. If the number on the red tab will be changed to 176 then the formula will work perfectly

 

[jonathanhili94]

So in column AH i have the hours that needs to be worked by the employees and in column AG i have the hours worked by the employees.

In column AL I need to know how many hours they worked but it must be more than 173.33.

so example if in AH4 is 2 in AL needs to be 2 but if AH5 is 180 in AL needs to 173.33

 

[Fluff]

Is the value in AL limited to 173.33 regardless of whether AG is less than, equal to or greater than AH?

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Problem trying to make the highlight column does not exceed 173.33
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.