Calculating Percentages in Excel (Part 2)

 

Finding one value as percentage of another

You will need to format the result as % by using the % button on the toolbar.

Example 3

An manager has been asked to submit budget requirements for next year.

The manger needs to specify what will be required each quarter.

The manager knows what has been spent by each region in the previous year.

By analyzing the past years spending, the manager hopes to predict what will need to be spent in the next year.

Finding an original value after an increase has been applied

Example 4

An employee has to submit an expenses claim for travelling and accommodation.

The claim needs to show the VAT tax portion of each receipt.

Unfortunately the receipts held by the employee only show the total amount.

The employee needs to split this total to show the original value and the VAT amount.