Prev: How do I see PDF comments in Excel insert object
Next: formatting for mail merge
From: star2q on 15 Apr 2010 13:59
How about an entire row and hide the formula???

"Steve Yandl" wrote:

> It's just a simple multiplication. If the start value is in A1
> =A1*1.1 is a 10% increase,
> =A1*1.15 is a 15% increase.
> =A1*1.20 is a 20% increase etc.
>
> Steve
>
>
> "RMPHELP" <RMPHELP(a)discussions.microsoft.com> wrote in message
> news:B1001063-AE5E-4E82-A189-3781AA9E3F64(a)microsoft.com...
> > This is probably very simple, but I am trying to write a formula to
> > increase
> > a number by 10%, 15% and 20%.
> >
> > For example, increasing 50000 by 10% with a result of 55000, by 15% =
> > 57500
> > and 20% = 60000.
>
>
>
From: Dianne on 15 Apr 2010 20:45

star2q;700345 Wrote:
>
How about an entire row and hide the formula???
>
> "Steve Yandl" wrote:
>
> > It's just a simple multiplication. If the start value is in A1
> > =A1*1.1 is a 10% increase,
> > =A1*1.15 is a 15% increase.
> > =A1*1.20 is a 20% increase etc.
> >
> > Steve
> >
> >
> > "RMPHELP" <RMPHELP(a)discussions.microsoft.com> wrote in message
> > news:B1001063-AE5E-4E82-A189-3781AA9E3F64(a)microsoft.com...
> > > This is probably very simple, but I am trying to write a formula
to
> > > increase
> > > a number by 10%, 15% and 20%.
> > >
> > > For example, increasing 50000 by 10% with a result of 55000, by 15%
=
> > > 57500
> > > and 20% = 60000.
> >
> >
> >



I would place 10%(A1), 15%(B1), 20%(C1) or any cells you choose.
A2 55000

B2 =A2+$A$1*A2

C2 =A2+$B$2*A2

D2 =A2+$C$1*A2

select b2 thru D2 and drag the lower right corner down the whole
column. To hide the formula, select the columns with formulas, format
cell, protection marked hidden and then protect the sheet. You will need
to unprotect the sheet to make changes unless you unlock cells that do
not contain the formulas.


--
Dianne
------------------------------------------------------------------------
Dianne's Profile: http://www.thecodecage.com/forumz/member.php?u=1755
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195938

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: How do I see PDF comments in Excel insert object
Next: formatting for mail merge