Percentages
| | | | |
| |
| | | | | | | | |
|
There are no specific functions for
calculating percentages.
| | | |
|
You have to use the skills you were
taught in your maths class at school!
| |
| | | | | | | | |
|
Finding a percentage of a
value
| | | | |
|
| ![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2n2WUIl-n-rUkqIS2EcIGE2WNZjxEiDnn-Tkc0xKMqDA_j8qn6t_heKZ0vJYZXhJwLYoBz6iYrhmJ0CVm8Oq9I2timIWDLxKnzbJXnd1dd2tFRhrQU7s0o8AP3OD354vySB-OG7NWl28/s1600/PIC1.png) |
|
|
|
|
|
|
| | Example 1 | | | | | | |
| | A company is about to give its staff
a pay rise. |
|
|
|
|
| The wages department need to
calculate the increases. |
|
|
|
| Staff on different grades get
different pay rises.
|
|
| |
| | | | | | | | |
| |
|
|
|
|
|
|
|
| Finding a percentage
increase | | | | |
| | ![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQ-ziWQNWTVXQdsIDXuzekgkYP3iobuCp5iU5O6U0Gifk1ScL8bHitDEXVel6WNzviFzVhoH9cRLLwlhhfkewJNRVmLr72OpbyA1qgMaDTK-ZzEipI9-ioFXfJhbPPHP0leBpzElNvK7w/s1600/PIC1.png) | | | | | | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Example 2 |
|
|
|
|
|
|
|
| A company is about to give its staff
a pay rise. |
|
|
|
|
| The wages department need to
calculate the new salary including the % increase. |
|
| Staff on different grades get
different pay rises.
|
|
|
|
|
|
|
|
|
|
|
|
|
| | | | | | | | |
| Finding one value as
percentage of another | | | |
| | | | | | | | |
|
| ![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMdnggh0uZARAodUsphooiYJXPsIF8q0EoGh7JDcb08gClrKqddjVrkNU5TRbhsgpXhyphenhyphenQyV6R66FTA7bJ5rLz23f_FW3_7S9VQioGLP4kv1C6XuHBEKbSbqkN9A7qA6eTKsHGzLE7FXj8/s1600/PIC5.png)
|
|
|
|
|
|
|
|
| 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 analysing 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![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpg-4MficK_rbrRbgsMQe6ft8Is1zDkdOLocAZTcf5jEIGPKux1IpmN9627IAhxosZjCX-YV_h1fx0iwf-knSAChCpcK2SD6xagwsDijO7mvqqQcrppiyNoePbnJGjKYzfgVUb-Xe_UFE/s400/PIC7.png) | | |
|
|
|
|
|
|
|
|
|
| | Example 4 |
|
|
|
|
|
|
|
| An employ 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. |
| | | | | | | | |
| |
|
|
|
|
|
|
|
|
| ![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMCsgKhU6YROhEMM1ZTxYFWR8RA8vOuSWRJ_emk3KnxN4Amv0ypA7X4-81r7NszQjQXRA3Ryf-_YL9SzAp5PXjUwaieAQV0WLlrFqE3qR5cdtd1jBJ4reaui1pkQLWiupAwBZ7764XVvE/s640/PIC8.png) |
|
| | | | |