To determine the percentage we have to divide the value by the total value and then multiply the resultant to 100. The result is shown as 016 because cell C2 is not formatted as a percentage. Y 100.
How to calculate percentage of a number.
If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. To find the percentage of a number you should look at the whole equal to 100 percent. Use tab to move to the next field. In the Home menu navigate to the Numbers menu.