Sure.
MIN(arg1,arg2,arg3,...) comes up with the Minimum value for the argument(s)
for it, likewise, MAX will come up with the Maximum arguments for it.
Your request was to take an amount, and increase it by 10% for the first 50,
and by 5% above and beyond 50.
Well, my formula:
MIN(A1,50) will take the minimum, of A1 or 50, and multiply it by 1.1 (or
itself and 10%). If A1>50, then 50 is the minimum, and this portion will
calculate to MIN(A1,50)*1.1 = 50*1.1 = 55. Likewise, if A1<50, then = 34*1.1
= 37.40. So that handles the first part of your request.
Next up, MAX(0,(A1-50)*1.05)
Well, if A1<50, such as 34 earlier, then we are looking for the maxium value
between 0 and (34-50)*1.05. The second argument will evaluate to a negative
number, and therefore, 0 is the maximum amount. However, if A1>50, then the
second argument will evaluate to a positive amount, and since I subtract it
by 50, then I multiply it by 1.05 (or itself and 5%). Therefore, your
original example of 100
=MIN(100,50)*1.1+MAX(0,(100-50)*1.05)
=50*1.1+MAX(0,50*1.05)
=55+52.5=107.50
Hope that helps