View Full Version : Excel Percentages

DeSade

24-05-2011, 05:02 PM

I have a table with numbers in it, lets say 20x20 table with figures in all squares.

The numbers have always been numbers for instance the total is say 12800, and this figure is split along the row but not evenly.

For instance

3000 6000 1500 1500

I need to show these numbers as a percentage of the whole from now on and going back over the old numbers.

For instance

25% 50% 12.5% 12.5%

Can anyone help?

SolMiester

24-05-2011, 05:18 PM

If the row of number you show starts at a1, then e1 would be total 12000

in B1 type =A1/$E$1% and copy to B2 to d2

Is that what you are after?

DeSade

24-05-2011, 06:25 PM

Does this help?

The total in this example is 100%

DeSade

25-05-2011, 12:54 AM

Sorted this out.

Its a little messy but it works.

SolMiester

25-05-2011, 10:34 AM

So, yeah, the formula I gave would work on that....

DeSade

25-05-2011, 10:55 AM

It didn't I couldn't figure out why.

In the end I just used =B57/Data!A1

and moved the line of totals to a hidden Data sheet to keep it relatively clean.

dugimodo

25-05-2011, 12:24 PM

I think the formula was backwards, should be $E$1/A1 which would give the fraction, or $E$1/A1*100 which would give the percentage

SolMiester

25-05-2011, 01:02 PM

Eh?

Works for me...look!..i just added % sign so dont have to format cells

dugimodo

25-05-2011, 01:53 PM

no you were right, I was looking at it wrong

DeSade

25-05-2011, 02:02 PM

I got yours working Sol, realized what I was doing wrong.

Thanks heaps that cleans up my sheet nicely.

SolMiester

25-05-2011, 02:37 PM

I got yours working Sol, realized what I was doing wrong.

Thanks heaps that cleans up my sheet nicely.

LOL, you had me going there for a moment!....

Lurking

25-05-2011, 06:42 PM

Have a similar exercise, as I have not done formulas for at least 19 years.

We play 2 games of indoor bowls and it's just a case of not having players in the same team over two games.

So it is mainly the Game 1 and Game 2 that need to be randomly sorted.

Thanks for this one too.

Lurking.

Ps. it's Open Office spreadsheet as I only have Excel 2000.

lurks.

Lurking

07-06-2011, 06:12 PM

Have a similar exercise, as I have not done formulas for at least 19 years.

We play 2 games of indoor bowls and it's just a case of not having players in the same team over two games.

So it is mainly the Game 1 and Game 2 that need to be randomly sorted.

Thanks for this one too.

Lurking.

Ps. it's Open Office spreadsheet as I only have Excel 2000.

lurks.

Think I may have found the solution for this, as attached.

Lurking.

Powered by vBulletin® Version 4.2.5 Copyright © 2019 vBulletin Solutions Inc. All rights reserved.