Percentage is a number or ratio that represents a fraction of 100. Where the 100 represents the whole (original) value. For instance 67% means 67/100.
Formula to calculate percentage in excel.
To calculate percentage in excel, your number should be in decimal form.
All you need is to click on the percentage sign (%) on the home tab.
Suppose you have values like 0.02, 0.003, 0.6, 0.012 and you are asked to find their percentages.
We begin by transferring the data to an excel spreadsheet then highlight the data and click on the percentage sign on the home tab and get your answer.
You can choose the number of decimal places you want in the home tab and near where you found the percentage sign (%).
In this case, lets use 2 decimal places.