Prev: adding spaces
Next: Cascading Drop-Down Lists
From: Chris on 8 Apr 2010 23:47
Cheers Mate
Worked perfectly
Chris
"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
First  |  Prev  | 
Pages: 1 2
Prev: adding spaces
Next: Cascading Drop-Down Lists