+ Reply to Thread
Results 1 to 4 of 4

increasing percentage

  1. #1
    S S
    Guest

    increasing percentage

    In cell B2 u have a monetry value, in C2 it increases 2.5% in cell D2 it
    increases a further 2.5% ansd so on for 10 years, In other words it adds on
    2.5% evry year.I currently do it manually, is there an easy formula that I
    could use to do this so that I would just put a value in B2 and have it do
    this.

    B2 Value
    In C2 value +2.5%
    In D2 value +5%
    In E2 value +7.5% continuing this increase of 2.5% to L2

    thanks



  2. #2
    Bernard Liengme
    Guest

    Re: increasing percentage

    If you really want simple interest (no compounding) use in C2:
    =$B$2*(1+2.5%*COLUMN(A2))
    Copy across the row

    For compounding use =B2*(1+2.5%)

    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "S S" <[email protected]> wrote in message
    news:[email protected]...
    > In cell B2 u have a monetry value, in C2 it increases 2.5% in cell D2 it
    > increases a further 2.5% ansd so on for 10 years, In other words it adds
    > on 2.5% evry year.I currently do it manually, is there an easy formula
    > that I could use to do this so that I would just put a value in B2 and
    > have it do this.
    >
    > B2 Value
    > In C2 value +2.5%
    > In D2 value +5%
    > In E2 value +7.5% continuing this increase of 2.5% to L2
    >
    > thanks
    >




  3. #3
    S S
    Guest

    Re: increasing percentage

    Ok thanks that works .


    "Bernard Liengme" <[email protected]> wrote in message
    news:u%[email protected]...
    > If you really want simple interest (no compounding) use in C2:
    > =$B$2*(1+2.5%*COLUMN(A2))
    > Copy across the row
    >
    > For compounding use =B2*(1+2.5%)
    >
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email
    >
    > "S S" <[email protected]> wrote in message
    > news:[email protected]...
    >> In cell B2 u have a monetry value, in C2 it increases 2.5% in cell D2 it
    >> increases a further 2.5% ansd so on for 10 years, In other words it adds
    >> on 2.5% evry year.I currently do it manually, is there an easy formula
    >> that I could use to do this so that I would just put a value in B2 and
    >> have it do this.
    >>
    >> B2 Value
    >> In C2 value +2.5%
    >> In D2 value +5%
    >> In E2 value +7.5% continuing this increase of 2.5% to L2
    >>
    >> thanks
    >>

    >
    >




  4. #4
    pdberger
    Guest

    Re: increasing percentage

    SS -- Another approach:

    A B
    1 Init $
    2 1 =$b$1*(1.025^a2)
    3 2 copy down

    Or you could set up the interest rate in C1 and use:

    =$B$1*((1+$C$1)^A2)

    to modify the interest rate as you go.

    HTH

    "S S" wrote:

    > Ok thanks that works .
    >
    >
    > "Bernard Liengme" <[email protected]> wrote in message
    > news:u%[email protected]...
    > > If you really want simple interest (no compounding) use in C2:
    > > =$B$2*(1+2.5%*COLUMN(A2))
    > > Copy across the row
    > >
    > > For compounding use =B2*(1+2.5%)
    > >
    > > --
    > > Bernard V Liengme
    > > www.stfx.ca/people/bliengme
    > > remove caps from email
    > >
    > > "S S" <[email protected]> wrote in message
    > > news:[email protected]...
    > >> In cell B2 u have a monetry value, in C2 it increases 2.5% in cell D2 it
    > >> increases a further 2.5% ansd so on for 10 years, In other words it adds
    > >> on 2.5% evry year.I currently do it manually, is there an easy formula
    > >> that I could use to do this so that I would just put a value in B2 and
    > >> have it do this.
    > >>
    > >> B2 Value
    > >> In C2 value +2.5%
    > >> In D2 value +5%
    > >> In E2 value +7.5% continuing this increase of 2.5% to L2
    > >>
    > >> thanks
    > >>

    > >
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1