+ Reply to Thread
Results 1 to 2 of 2

Different percentages in relation to the same number (cell)

Hybrid View

  1. #1
    Registered User
    Join Date
    09-01-2016
    Location
    Jylland, Denmark
    MS-Off Ver
    2016
    Posts
    1

    Question Different percentages in relation to the same number (cell)

    Hi!

    I really hoping someone can help me! I have looked online for an answer for an hour now.

    The thing is I'm making a Spreadsheet for a weight loss course. I have everything figured out except the percentage part.

    I need to have an automatic calculation which calculates the the percentage of the overall weight loss from beginning to now. It's set up so that the participants (in the weight loss program) enter their weight every day. Then i need it to calculate how big a percentages of their stating body weigt they have lost. the program is over 95 days so i need to be able to do that drag thing to duplicate the formula.

    I have tried it but the it keep taking the weight from the cell above (the day before) and calculating how many percentages you have lost until now.

    I really hope you can help! By all means write me if my explanation isn't sufficient.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,785

    Re: Different percentages in relation to the same number (cell)

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-03-2015, 03:01 PM
  2. [SOLVED] Indent in relation to numeric cell value
    By jason.hampton in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-08-2013, 02:46 PM
  3. [SOLVED] Find the row number of an ID in relation to the first time that ID appears
    By cfoxc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2012, 06:10 PM
  4. Replies: 2
    Last Post: 12-24-2009, 02:58 PM
  5. Replies: 1
    Last Post: 07-12-2007, 05:45 PM
  6. Cell relation ships.
    By Slukes in forum Excel General
    Replies: 3
    Last Post: 04-02-2005, 08:06 AM

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