Calculation
"vegaanders" wrote:
Is it possible for Excel to make a calculation like this?
In column ! I have Numeric values. In Column B I want
the value from column A +15%. But if this 15% is less
then 0.01 I want 0.01 to be added instead.
=A1 + max(0.01, A1*15%)
Does it bother you that the result will be 0.01 even if A1
is zero? Would you prefer zero in that case, instead?
If so:
=A1 + (A10)*max(0.01, A1*15%)
|