Open up the Format Cells dialog box by either. C6 C11. Formula for Grade in Excel.
Now to calculate the percentage of marks obtain by Stieve in the test we have to type the formula.
Method 2 - Percentage Formatting Through the Format Cells Dialog Box. Second you can apply formulas to calculate the. Method 2 - Percentage Formatting Through the Format Cells Dialog Box. 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.