Microsoft Excel | Page Five | Applying Formulae

Guidelines focus on formulae (pl) but you might also endeavour to apply formatting (illustrated) where appropriate.

Page: 1 of 6 | 2 of 6 | 3 of 6 | 4 of 6 | 5 of 6 | 6 of 6

Applying Formulae (pl)

Applying formulae to achieve a percentage increase
A percentage increase, in price for example, can be achieved by dividing the difference (increase in cost) over the original cost including % (See: D2).

Applying formulae to achieve a percentage decrease
A percentage decrease can also be achieved by dividing the difference (decrease in cost) over the original cost including %. However, here I have arrived at the difference by subtracting the old from new (within a set of parenthesis) to control appearance (D2). This method (formula make-up) used here to show the minus symbol in the result.

Applying formulae to achieve a random increase/decrease
To create a new total based on a random percent increase or decrease, firstly enter the following:

Change the percentage in cell B2 and observe the result at C2.

Adapt the formula to show an increased amount based on the percent entered.

For example: =A2/100*(100+B2)

Remember to also change your column heading at B1.

Applying formulae to achieve a proportional percentage
What percentage is 25 from 58. The cell reference (Quantity) for each item is divided by the total quantity of all items (%) giving a proportional total.

It may help to include an absolute reference ($) to the formula (Reference to row 4) to fix the row, to ensure that it doesn't change if replicated.

For example: =B2/B$4% (See: Absolute reference).

This formula will perhaps allow you to compare sales of one item against another. Note also, two differing method for totalling the columns, the latter method at C4 normally used to calculate random cells.

Applying formulae to measure proficiency
Here a standard time (Minutes set for any given task) is divided by minutes taken (including %) to give a measure of proficiency.

Page: 1 of 6 | 2 of 6 | 3 of 6 | 4 of 6 | 5 of 6 | 6 of 6

Top