+ Reply to Thread
Results 1 to 3 of 3

Peercent change question

  1. #1
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2016 Mac
    Posts
    268

    Peercent change question

    Good afternoon,

    I am trying to calculate the percent change question. I know the basics of calculating the percent change (new-old/old). what I'm trying to do is find th percent change from a starting weight and the most recent weight.

    What i have is a column with the weights entered

    In Column B1

    175
    174.3
    173
    174
    172.8
    170.3
    169
    169.5
    166.2

    What i need to do is calculate the percent change ion the first and last cells as they are entered weekly so can give updates. i need it to automatically use the latest data entered.

    Any help would be greatly appreciated.

    TIA

    Los

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Peercent change question

    Try

    =(LOOKUP(99999,$B$2:B100)-$B$2)/$B$2

    first weight in B2

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Peercent change question

    =(b1-lookup(99^99,$b:$b))/b1

+ 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. Sheet Change Question
    By Yakov on Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2016, 06:17 PM
  2. Formula change question
    By Brian63 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-26-2012, 07:57 PM
  3. Percent change question
    By esion9302 in forum Excel General
    Replies: 6
    Last Post: 07-12-2010, 12:48 PM
  4. % Change Question
    By StephanieJ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2007, 07:40 PM
  5. Event Change Question
    By pikapika13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2006, 02:10 PM
  6. VLOOKUP change question
    By roger_home in forum Excel General
    Replies: 6
    Last Post: 02-25-2006, 07:10 PM
  7. Another change event question
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-27-2005, 07:06 PM

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