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.

Level 1

4 points

Percentages/Numbers

Hi,

I'd like to insert a formula in numbers to calculate a value as a percentage of a value.

e.g I'd like a row to to display 20% of another row. Any advice please.

Thank you!

Nigel

MacBook, macOS 10.12

Posted on Apr 30, 2020 2:47 AM

Top-ranking reply

Level 7

28,324 points

Posted on Apr 30, 2020 3:36 AM

"20% of a number" can also be said as "20% times a number".

20% is the same as 0.20

If your number is in cell B2, a formula to calculate 20% of it would be either

=20%*B2

=0.20*B2

View in context

Similar questions