Excel Percentage Calculator

The above Excel Percentage spreadsheet calculates two different types of percentage. These are:
Percentage Change Example:
Month 1 sales: $1,000
Month 2 sales: $1,200 Percentage change from Month 1 to Month 2 = +20% I.e. Sales have increased by 20% in Month 2, compared to Month 1. 
Percentage as a Proportion Example:
Sales of Widgets: $300
Total Sales: $1,000 Sales of Widgets as a proportion of Total Sales = 30% I.e. Sales of Widgets accounted for 30% of the Total Sales. 
For details on the formulas used to calculate these two percentages, see the Calculating Percentages in Excel page.
The Excel functions and operators used in the downloadable Percentage Spreadsheet are:
 / operators  The subtraction and division operators are used in the percentage calculations. 
If function  Used to keep the spreadsheet tidy. If the number fields do not contain numeric values, the result is displayed as a blank cell. 
Isnumber function  Used to check if numeric values are present in the Number fields of the spreadsheet. 