Prev: adding spaces
Next: Cascading Drop-Down Lists
From: Chris on 7 Apr 2010 20:26
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
From: ozgrid.com on 7 Apr 2010 20:47
This should get you there;
http://www.ozgrid.com/Excel/cell-lookup.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Chris" <Chris(a)discussions.microsoft.com> wrote in message
news:1C0F4143-B955-4ECE-AE89-CC20133A0AC2(a)microsoft.com...
> 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

From: aquaxander on 8 Apr 2010 06:44
Try "If" statement within an "If" statement:
=IF(B53>0,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
From: aquaxander on 8 Apr 2010 06:49
Sorry, do you mean:
=IF(B53>0,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(B53>0,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
From: Joe User on 8 Apr 2010 11:11
"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
 |  Next  |  Last
Pages: 1 2
Prev: adding spaces
Next: Cascading Drop-Down Lists