Help Needed with Percentages in Numbers App

Question

Level 1

4 points

Help Needed with Percentages in Numbers App

Hi everyone,

I’ve been working on a spreadsheet in Numbers to calculate percentages for a budgeting project, but I’m finding it tricky to set up formulas for things like percentage increases or working backward from a total.

I’ve been using www.percentagescalculator.co.uk to verify my results manually, which has been super helpful, but I’d love to know if there’s a way to replicate these calculations directly in Numbers.

Does anyone have any tips or examples of formulas they’ve used for this kind of thing?

Thanks in advance!

MacBook Pro (M1, 2020)

Posted on Nov 23, 2024 7:28 AM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

28,288 points

Nov 23, 2024 5:25 PM in response to stey999

20% is the same as 0.20 which is 20/100.

What is 20% of 50?

50*20% = 50*0.20 = 10

If cell B2 has 50 and B3 has 20% then the formula would be =B2*B3 and format the result as percentage

10 is what percent of 50?

10 = 50*X

X = 10/50 = 0.20 = 20%

If cell B2 has 10 and B3 has 50 then the formula would be =B2/B3 and format it as percentage

Percentage change from 50 to 75?

The change is 75-50 = 25

50*X = (75-50) = 25

X = 25/50 = 0.50 = 50%

If B2 has 50 and B3 has 75 then the formula would be =(B3-B2)/B2 and format as percentage

Reply