PDA

View Full Version : Excel Percentages

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?

24-05-2011, 06:25 PM
Does this help?

The total in this example is 100%

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....

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

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.