The “%” button changes cell values to a percentage.
With the formulas in place, if we decide to change any of the values in the cell range then all formulas will re-calculate.
Excel Help File Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of a total, for example, or the percentage difference between two numbers.
Windows
macOS
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Find the percentage of a total
Say that your company sold $125,000 this quarter, and you need to find out what percentage $20,000 is of the total.