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

Reply

Best reply

Level 7

25,850 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

or

=0.20*B2

View in context

Similar questions