Min and Max Calculated on Other Cells

[dave5770]

Hi,

I am trying to calculate the minimum and maximum amount the value of a cell based on another cell and cannot figure it out. I have never used this function.

Helpful (hopefully) example. the max allowable increase is 10% but the below increase is 15%, so I would want the result to max out at 10% no matter the amount of the increase entered.

A1: original amount - 1,000
A2: increase - 150
A3: % increase - 15%
A4: new amount - 1,100 - the result is $1,100 even though a 150 increase is 15%

Can anyone help?

 

[Fluff]

How about
=MIN(SUM(A1:A2),A1*1.1)

 

[dave5770]

Thank you!

 

[Fluff]

You're welcome