+ Reply to Thread
Results 1 to 5 of 5

excel sales increase

  1. #1
    Registered User
    Join Date
    11-11-2006
    Posts
    1

    excel sales increase

    Hello everyone,

    I have created the below spreadsheet and I now need to calculate the sales increase and percentage increase and later create suitable charts to illustrate the figures

    http://img296.imageshack.us/img296/3...ncreasebm1.jpg

    So how should I write the forumla which will show the sales increase(in cell G18) between 2005-2006 and the percentage sales increase ( in cell G20)

    A newbie question I know but I'm new to excel
    thanks

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by shawnjohnson
    Hello everyone,

    I have created the below spreadsheet and I now need to calculate the sales increase and percentage increase and later create suitable charts to illustrate the figures

    http://img296.imageshack.us/img296/3...ncreasebm1.jpg

    So how should I write the forumla which will show the sales increase(in cell G18) between 2005-2006 and the percentage sales increase ( in cell G20)

    A newbie question I know but I'm new to excel
    thanks
    I presume that D16 has the formula =Sum(D10:D14) and G16 has =Sum(G10:G14), then, ignoring the inherant dangers of referencing cells in other rows, G18 will have

    =G16-D16)

    and G20 have

    = G18/D16*100

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    10-18-2006
    Posts
    49
    can you post the sample values or the file itself, i'll fill the formulas for you.
    the jpg link you sent isn't working for me due to a firewall

  4. #4
    Registered User
    Join Date
    11-16-2006
    Posts
    3
    Hello everyone,

    I am a new user in this site.

    I have some basic excel experience. I would be glad if someone would give me some advice on what tutorial software can I use to study some more excel. I would be really greatfull, because I know little and I am expected to do lot at my work

    John

  5. #5
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by johntarazhi
    Hello everyone,

    I am a new user in this site.

    I have some basic excel experience. I would be glad if someone would give me some advice on what tutorial software can I use to study some more excel. I would be really greatfull, because I know little and I am expected to do lot at my work

    John
    download Excel books from here

    http://www.oebook.com/{5B52E985-BAB6...C234A711F}.htm

    http://www.oebook.com/{B5AE0032-B3F3...41AE5182C}.htm

    http://www.oebook.com/{5906DB2E-4A94...605C097A9}.htm

    you can search on the same website for more books

+ 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