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.

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 4:28 PM

Reply
Question marked as Top-ranking reply

Posted on Jul 6, 2019 1: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

1 reply

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.