In Excel the formula to calculate this example would be 50100. This will tell you. Keep selecting the result cell then click the Percent Style button in the Number group under Home tab to format the cell as percentage.
We need the values in the percentage form.
Lets start with a new example. Right clicking on the selected cell and from the right-click menu selecting the F ormat Cells. Enter a decimal number 02 in cell B1 and apply a Percentage format. Open up the Format Cells dialog box by either.