Level 1

4 points

How to do a formula on Numbers to get the percentage

How can I do a formula on number to get the percentage of in amount

[Re-Titled by Moderator]

Posted on Jul 3, 2019 04:28 PM

Reply

Top-ranking reply

Level 8

37,214 points

Posted on Jul 6, 2019 01:03 AM

Let's say you have the total in B2. You have another number in C2. In D2 you want to display what percentage of B2 your number in C2 is. The formula in D2 would be =C2/B2. Then set the Data Format of cell D2 to 'Percentage'.

SG

View in context

Similar questions

1 reply

Top-ranking reply

Level 8

37,214 points

Jul 6, 2019 01:03 AM in response to cruz65

Let's say you have the total in B2. You have another number in C2. In D2 you want to display what percentage of B2 your number in C2 is. The formula in D2 would be =C2/B2. Then set the Data Format of cell D2 to 'Percentage'.

SG

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to do a formula on Numbers to get the percentage

Welcome to Apple Support Community

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

Learn more Sign up