| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 118194 | 2011-05-24 05:02:00 | Excel Percentages | DeSade (984) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1204451 | 2011-05-24 05:02:00 | 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? |
DeSade (984) | ||
| 1204452 | 2011-05-24 05:18:00 | 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? |
SolMiester (139) | ||
| 1204453 | 2011-05-24 06:25:00 | Does this help? The total in this example is 100% |
DeSade (984) | ||
| 1204454 | 2011-05-24 12:54:00 | Sorted this out. Its a little messy but it works. |
DeSade (984) | ||
| 1204455 | 2011-05-24 22:34:00 | So, yeah, the formula I gave would work on that.... | SolMiester (139) | ||
| 1204456 | 2011-05-24 22:55:00 | 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. |
DeSade (984) | ||
| 1204457 | 2011-05-25 00:24:00 | 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 | dugimodo (138) | ||
| 1204458 | 2011-05-25 01:02:00 | Eh? Works for me...look!..i just added % sign so dont have to format cells |
SolMiester (139) | ||
| 1204459 | 2011-05-25 01:53:00 | no you were right, I was looking at it wrong | dugimodo (138) | ||
| 1204460 | 2011-05-25 02:02:00 | I got yours working Sol, realized what I was doing wrong. Thanks heaps that cleans up my sheet nicely. |
DeSade (984) | ||
| 1 2 | |||||