Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.

37 percent of the people who spend more than half of their day working in Excel have never received any formal training. Office working looking at an Excel spreadsheet. Image by Tim Sandle Office ...