Thread: Calculation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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%)