+ Reply to Thread
Results 1 to 11 of 11

Add percentage to figures then show on a secon tab

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Towcester
    MS-Off Ver
    Excel 2010
    Posts
    6

    Add percentage to figures then show on a secon tab

    Hi
    I have a spread sheet with a large number of costings on, I now need to add a percentage on to those figures and have them on a second tab then add adifferent percentage on and show them on a third tab and so on.
    Basically the original spread sheet is cost price, the second tab to include labour, the third tab to include output tax etc.

    The second bit of advice I'm looking for is probably much simpler, how do I keep the title and the headings fixed whilst the rest of the spreadsheet scrolls up ?

    Many thans

    Pete

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Add percentage to figures then show on a secon tab

    On the first Tab(Say Sheet1) you have the data

    On the Second Tab you could have a formula like this:
    +Sheet1!A1*1.1 {Add 10% to the value}

    You could do something similar on the other Tabs

    How do I keep the title and the headings fixed whilst the rest of the spreadsheet scrolls up ?
    What you want is Freeze Panes
    Click on star (*) below if this helps

  3. #3
    Registered User
    Join Date
    08-15-2012
    Location
    Towcester
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Add percentage to figures then show on a secon tab

    Thanks for that but I presume that would add 10% to everything how can I do it to specific cells or columns because some of the columns contain figures that have to remain the same.

    Pete

  4. #4
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Add percentage to figures then show on a secon tab

    +Sheet1!A1*1.1 {Changes that cell only}
    You could copy this formula as necessary

    This doesn't preclude from have different formulas for other cells

    Perhaps you need to upload a sample worksheet

  5. #5
    Registered User
    Join Date
    08-15-2012
    Location
    Towcester
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Add percentage to figures then show on a secon tab

    Sorry to be a pain but what would I put in to do it with a column or a row or a block of columns and rows ?

    Thanks for your help mate

  6. #6
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Add percentage to figures then show on a secon tab

    Beacuse you are having trouble understanding, perhaps you should upload a sample workbook

  7. #7
    Registered User
    Join Date
    08-15-2012
    Location
    Towcester
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Add percentage to figures then show on a secon tab

    Quote Originally Posted by K m View Post
    Beacuse you are having trouble understanding, perhaps you should upload a sample workbook
    Honestly I get what you have said so far thank you but just needed to know how do the formula for a column or a block of columns and rows because that will speed it up for me.

    Thanks for your help

    Pete

  8. #8
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Add percentage to figures then show on a secon tab

    Just copy this formula down or right as you need

    +Sheet1!A1*1.1

    If you copy the formula down one row, the formula becomes =Sheet1!A2*1.1; etc.

  9. #9
    Registered User
    Join Date
    08-15-2012
    Location
    Towcester
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Add percentage to figures then show on a secon tab

    Hi
    I think i will download a template so that i can see where the formula has to be put as i really have no idea.
    Where can i download a template from?

    Thanks again for your help

    Pete

  10. #10
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Add percentage to figures then show on a secon tab

    You need to make it

  11. #11
    Registered User
    Join Date
    08-15-2012
    Location
    Towcester
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Add percentage to figures then show on a secon tab

    Ok think maybe I need to get somebody to help me

+ 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