Calculation

V

vegaanders

Hi all!
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.

If this is possible how should this formula look like?

Hope someone understand

Thanks in advance

Anders Svensson
 
J

joeu2004

vegaanders said:
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.
Click to expand...

=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 + (A1>0)*max(0.01, A1*15%)
 
N

nastech

should be easy, but did not quite get info need: if column ! ???
anyways, something like:

=IF((your equation)<.01,.01,"") or

=IF((B133*15%)<0.01,0.01,"")
 
Top