Divide the whole amount by the number of parts in the bar. This gives the value of one percentage part. Multiply the value of one part by the number of parts needed to make the percentage.
How-To Geek on MSN6d
Use the PERCENTOF Function to Simplify Percentage Calculations in ExcelExcel'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.
Divide the whole amount by the number of parts in the bar. This gives the value of one percentage part. Multiply the value of one part by the number of parts needed to make the percentage.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback