Excel's PERCENTOF function returns the percentage that ... such as field headers, sort order, and filter array, but I've left these out in this example to show you how to use it with PERCENTOF ...