Question: how to calculate percentage in excel using if function?
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.