| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Hi All
I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.49 (C38 less 10%) Thanks Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
This should get you there;
http://www.ozgrid.com/Excel/cell-lookup.htm -- Regards Dave Hawley www.ozgrid.com "Chris" wrote in message ... Hi All I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.49 (C38 less 10%) Thanks Chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Try "If" statement within an "If" statement:
=IF(B530,C38*110%,IF(B53<0,C38*90%,0)) I hope that works! "Chris" wrote: Hi All I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.49 (C38 less 10%) Thanks Chris |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Sorry, do you mean:
=IF(B530,C38*(100+B53)/100,IF(B53<0,C38*(100+B53)/100,0)) this is better!!! "aquaxander" wrote: Try "If" statement within an "If" statement: =IF(B530,C38*110%,IF(B53<0,C38*90%,0)) I hope that works! "Chris" wrote: Hi All I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.49 (C38 less 10%) Thanks Chris |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
"Chris" wrote:
I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. To do what you ask for literally: =C38*(1+SIGN(B53)*10%) But if B53 is the percentage (e.g. 10 for 10%), then: =C38*(1+B53/100) ----- original message ----- "Chris" wrote: Hi All I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.49 (C38 less 10%) Thanks Chris |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Cheers Mate
Worked perfectly Chris "aquaxander" wrote: Try "If" statement within an "If" statement: =IF(B530,C38*110%,IF(B53<0,C38*90%,0)) I hope that works! "Chris" wrote: Hi All I have a cell that I need to return a value that is either 10% more if another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10, C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should = 14.49 (C38 less 10%) Thanks Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
