Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

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

MRMARRISON Author

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

Best reply

Badunit

Level 7

26,104 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

Percentages/Numbers

Similar questions