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