Home » Excel-Templates » Excel-Percentage-Calculator

# Excel Percentage Calculator

| Excel Percentage Calculator Excel 2003 and later | Simple Excel spreadsheet with formulas to calculate percentages either as a percentage change or as a proportion. |
Download Now |

## Excel Percentage Calculations

The above Excel Percentage spreadsheet calculates two different types of percentage. These are:

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. | 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.

## Functions Used in the Excel Percentage Calculator

The Excel functions and operators used in the above 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. |