I have a block of cells with numbers like 4, 3, 5, etc, that relate to a total of 20. However, when formatting with percentage, it appears 400%, 300%, 500%, etc. How do I fix that? 4 should be 20% of 20, for example.
To show a relationship between a partial and a total, you need to calculate. Calculation is not done by format, but by formula.
What you need is a simple division.
=<partial>/<total>
Enter the formula in a separate cell, beside your actual figure, and replace <partial> and <total> by cell addresses. (While entering a formula in a cell, you can click other cells to insert their address into your formula).
When you format your formula cell as percent, you will get what you expected.
1 Like