| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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%) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation speed issue | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Hybrid Mode
