Question: how do i create a formula in excel to calculate percentage?
Answer: Enter the formula =C2/B2 in cell D2, and copy it down to as many rows as you need.
Click the Percent Style button (Home tab > Number group) to display the resulting decimal fractions as percentages.