Formula Help

[Chris]

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

 

[ozgrid.com]

This should get you there;
http://www.ozgrid.com/Excel/cell-lookup.htm

 

[aquaxander]

Try "If" statement within an "If" statement:
=IF(B53>0,C38*110%,IF(B53<0,C38*90%,0))
I hope that works!

 

[aquaxander]

Sorry, do you mean:
=IF(B53>0,C38*(100+B53)/100,IF(B53<0,C38*(100+B53)/100,0))
this is better!!!

 

[Joe User]

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]

Cheers Mate
Worked perfectly
Chris

Try "If" statement within an "If" statement:
=IF(B53>0,C38*110%,IF(B53<0,C38*90%,0))
I hope that works!