PERCENTILE PERCENTILEEXC and PERCENTILEINC function. We want to show the total estimated amount not just the increase. F3-E3E3 The result will appear in the cell.
Percentage of Total 1.
Click the insert function button fx under formula toolbar the dialog box will appear Type the keyword PERCENTILE in the search for a function box PERCENTILE function will appear in select a function box. PartTotal100 Lets do this in excel. Click the Percent Style button Home tab Number group to display the resulting decimal fractions as percentages. Press Tab then in B18 enter this Excel percentage formula.