Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > work out % in simple excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

work out % in simple excel

Reply to Message Icon

Name: heardy
Date: January 5, 2006 at 01:59:26 Pacific
OS: winxp
CPU/Ram: 1gb
Comment:

Hi There,

I'm not very good with excel so bear with me.
I have a spreadsheet with a weight of 102.5 in cell A1, and in A2 i have a weight of 101, what i want to do is work out the percentage loss in cell B1 overall, so as i keep losing weight and entering my next weights as i go down the column, this figure in B1 will keep working out the percentage loss from when i first started (ie 102.5)

any help woulb be great



Sponsored Link
Ads by Google

Response Number 1
Name: wizard-fred
Date: January 5, 2006 at 07:08:44 Pacific
Reply:

Your starting reference is A1. If B1 is the percentage gain(loss) overall then it has to reference the most recent weight. The layout is awkwark if you have B1 dependent on the last entry.


0

Response Number 2
Name: heardy
Date: January 5, 2006 at 07:49:47 Pacific
Reply:

they are not specific cells, just used as an example.
all i need is if 102 is in one cell, and 101 is in another cell, i need a formula in a 3rd cell that works out my percentage weight loss.

many thanks


0

Response Number 3
Name: mesich
Date: January 5, 2006 at 08:01:57 Pacific
Reply:

Hi heardy, wizard fred, hello everyone,

heardy,

A1 for your starting weight

B1 for your current weight

C1 =100%-A1/A2

Include the equals sign in C1, it's not showing up in bold here for some reason.

Best Regards,
Mesich



0

Response Number 4
Name: Jennifer SUMN
Date: January 5, 2006 at 08:08:04 Pacific
Reply:

I haven't weighed 102 pounds since I was 12.

Soylent Green is PEOPLE!!!


0

Response Number 5
Name: Jennifer SUMN
Date: January 5, 2006 at 08:08:54 Pacific
Reply:

Sorry. Typing what I'm thinking. LOL

Soylent Green is PEOPLE!!!


0

Related Posts

See More



Response Number 6
Name: mesich
Date: January 5, 2006 at 08:16:29 Pacific
Reply:

Hi Jennifer SUMN,

LOL!

I haven't checked for sure but I believe my right leg weighs that. :-)

Best Regards,
Mesich



0

Response Number 7
Name: Bryco
Date: January 5, 2006 at 12:32:57 Pacific
Reply:

Jenn - LOL

Mesich - What happened to Mesich.com? I see that you still have it as a homepage but it shows as Suspended when visiting it.

Bryan


0

Response Number 8
Name: wizard-fred
Date: January 5, 2006 at 13:08:32 Pacific
Reply:

mesich: The 100% should be subtracted to properly show the direction of change and the new/old has to be converted to a percentage.

More frequently percentage change is shown as:
((new weight - old weight) / old weight) * 100



0

Response Number 9
Name: heardy
Date: January 6, 2006 at 01:07:11 Pacific
Reply:

Hi All, and thanks for the comments, and just to let you all know i'm talking Kg's not pounds, so i'm quite a big lad!

Wizard fred, how would this formula be written?
Would it not be ((old weight - new weight) / old weight)*100??

Many Thanks all


0

Response Number 10
Name: wizard-fred
Date: January 6, 2006 at 01:37:17 Pacific
Reply:

The old weight is the reference. If the new weight is less than the old weight then the weight change is negative. Assuming old weight is 200 pounds, new weight 190 pounds, change is -10 pounds, percent loss is 5% (-10/200)* 100


0

Response Number 11
Name: mesich
Date: January 7, 2006 at 07:30:15 Pacific
Reply:

Hello everyone,

Hi wizard-fred,

You are correct, thanks for pointing that out.

Hi Bryan,

It should be back up shortly, we were hoping to have it back up and running earlier this week. I removed the website link from My Computing.net and also changed the email address to a secondary.

Best Regards,
Mesich



0

Response Number 12
Name: wizard-fred
Date: January 7, 2006 at 13:23:06 Pacific
Reply:

A major minor correction the example should show a -5%.


0

Sponsored Link
Ads by Google
Reply to Message Icon



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: work out % in simple excel
Paste greyed out in Word 2002 www.computing.net/answers/office/paste-greyed-out-in-word-2002/5307.html

detecting ANY character in a cell www.computing.net/answers/office/detecting-any-character-in-a-cell/3101.html

Simple Excel Conditional Formula www.computing.net/answers/office/simple-excel-conditional-formula/7019.html