Calculation
 

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


--
vegaanders
------------------------------------------------------------------------
vegaanders's Profile: http://www.excelforum.com/member.php...o&userid=33743
View this thread: http://www.excelforum.com/showthread...hreadid=535182

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%)

Calculation
 

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,"")

"vegaanders" wrote:


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


--
vegaanders
------------------------------------------------------------------------
vegaanders's Profile: http://www.excelforum.com/member.php...o&userid=33743
View this thread: http://www.excelforum.com/showthread...hreadid=535182