The excel formula for percentage is Portion Days Total Days 100. Enter the total to date in another cell. You can calculate percentages in Excel using basic multiplication and division.
Enter the total to date in another cell.
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. How to Calculate a Percentage of a Number. In an empty cell enter one of the below formulas. A1A5 Percentage formatting is applied to Columns B and C.