+ Reply to Thread
Results 1 to 3 of 3

Weight lost code

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,812

    Weight lost code

    I am creating a chart.

    Here is my scenario.

    Cell A1 I entered 170 starting weight and in Cell B1 I will be entering 165 new weight so then the result weight should show -5 of lost weight (with a negative sign) in cell C1. If I entered 175 in cell B1 it should show +5 (with a possitive sign).
    In cell H1 need a code a total percentage of lost weight.
    If you can please create me a code in C1 to show the result of negative or positive result.

    Thank you

  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
    30,752

    Re: Weight lost code

    in C1

    =A1-B1

    =In H1

    =C1/A1 format as percentage

  3. #3
    Registered User
    Join Date
    06-10-2014
    Posts
    10

    Re: Weight lost code

    See attached, take a look at the formula line - but it is as above, with the cells formatted.
    Attached Files Attached Files

+ 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. Help calculating the total weight lost from starting weight D1
    By rgainey201 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-31-2014, 06:16 PM
  2. Lost spaces and Zeros lost when replacing text
    By renshawk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2013, 04:50 AM
  3. Auto Calculate Shipping Weight/Cartons and Package Weight.
    By suhailsiddiqui09 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2013, 06:48 AM
  4. Replies: 10
    Last Post: 01-28-2013, 07:41 PM
  5. Replies: 4
    Last Post: 07-01-2012, 07:24 PM
  6. Calculations for total body weight lost/gained.
    By saitek in forum Excel - New Users/Basics
    Replies: 19
    Last Post: 01-20-2009, 08:05 PM
  7. [SOLVED] Weight loss line chart to monitor weight loss progress
    By S Fox in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-08-2005, 01:15 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