You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Working out percentages in numbers please

Can anyone help me please work out how I set up a formula to work out the following.


1st column total 22 % second column 12.8% and have the third column add the percentage together the fourth column whats left .

MacBook Air

Posted on Jan 23, 2020 5:52 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 23, 2020 11:36 PM

Hi gc,


22& of what?

12.8% of what?

'what's left' from what?


Wu=ith some assumptions regarding answers to the questions:


Formulas:


B2: $A2×B$1

Fill right to cell C2


D2: A2−B2−C2


Assumptions:


All percentages are percentages of the original amount.

"What's left" is the original amount minus both percentage results.


Regards,

Barry

1 reply
Question marked as Top-ranking reply

Jan 23, 2020 11:36 PM in response to giantchopper

Hi gc,


22& of what?

12.8% of what?

'what's left' from what?


Wu=ith some assumptions regarding answers to the questions:


Formulas:


B2: $A2×B$1

Fill right to cell C2


D2: A2−B2−C2


Assumptions:


All percentages are percentages of the original amount.

"What's left" is the original amount minus both percentage results.


Regards,

Barry

Working out percentages in numbers please

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.