Modify An If Statement To Return A Max Value

Hi All,

I'm hoping I can get some help in modifying this function. I've simplified the function to include numbers rather than cell references for the portions of the function that are doing computations. I don't know if more information will be necessary to help me, but I will start with this and add additional information as necessary. How would I modify the function so that the active cell would automatically return 100 if the value of the computations, regardless of which one it runs, was greater than 100?

HTML Code: 

Thanks in advance for any help on this. I did try adding another logic criteria to the AND portion of the initial function, but couldn't figure out how to make it work.

Matt

TMS,

Thank you for your help! This appears to work as intended. I appreciate the help.

Bebo021999,

I apologize for any confusion. I hadn't checked the values to ensure they were less than a hundred. I didn't think the constraint values would be necessary to help me in this instance. The MIN function that TMS suggested seems to have worked perfectly. Thanks for your help.