Question

How can you find 22% of £1,677,152.64 using Excel?

Answer 1

22% of £1,677,152.64 is £368,973.58

Excel formula:

Let cell A1 = the given result (£368,973.58 in this problem)
Let cell B1 = the given percent (22 in this problem)
Let cell C1 be the answer which will have the formula "=(A1 * 100)/B1"

Explanation:

"Percent" or "%" means "out of 100" or "per 100", Therefore 22% can be written as `22/100`.

When dealing with percents the word "of" means "times" or "to multiply".

Finally, lets call the number we are looking for "n".

Putting this altogether we can write this equation and solve for `n` while keeping the equation balanced:

`368973.58 = 22/100 xx n`

`color(red)(100)/color(blue)(22) xx 368973.58 = color(red)(100)/color(blue)(22) xx 22/100 xx n`

`36897358.00/color(blue)(22) = cancel(color(red)(100))/cancel(color(blue)(22)) xx color(blue)(cancel(color(black)(22)))/color(red)(cancel(color(black)(100))) xx n`

`1677152.64 = n`

`n = 1677152.64`