Adding a "not to exceed" condition to existing formula

I'm preparing Quarterly Evaluations, and am having an issue because an Analyst has superseded an overall percentage goal. In the attached example, it is the overall evaluation with the 'problem data' in red D19 and highlighted.

I'd like to add a condition that limits the points in D19 for 'responsibility 3' to 150.

=IF(ISERROR(C19/B19)*(B10),"-",(C19/B19)*(B10))

*just a note for clarification, the other two responsibilities are a 'per hour' weekly goal, whereas the 3rd is an overall personal effort divided from the overall team effort.

Thank you in advance for any help given

Use this in D19 to set an upper limit of 150 to the result:

Formula:

Please Login or Register  to view this content.

Edit: I think you have an error in your original formula. You need an extra set of parentheses, see the red parens above. I did not test this with an error condition.

Awesome, works perfectly -- I had a feeling it would be a MIN, but I'm still so-so at analyzing and revising already existing formulas.

Thanks again, 6StringJazzer!!