Excel's PERCENTOF function returns the percentage that a subset of data ... of a single value against an overall total. In this example, let's say you've been asked to analyze the June performance ...

It is possible to show the used or applied formula and hide the actual result in any cell in Microsoft Excel using this tutorial ... to display the sum of cells, percentage of something, etc.