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

alistair140 Author

Level 1

4 points

Numbers

Using numbers how do I apply a percentage to a column ?

Posted on Jan 18, 2021 10:27 AM

Top-ranking reply

Level 5

4,933 points

Posted on Jan 18, 2021 1:37 PM

Not entirely sure what you mean, but if you have a column of figures starting at B2 and want to find 50% of each, then type in the following formula in C2:

That's

=B2×50%

and fill down the remainder of column C by dragging the yellow dot.

View in context

Similar questions

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
259 1
How to add a Divide in a simple fumula ? Simple question please : I want to add a percents to the third column Cant insert the / mark , it's always + instead of / Any advise will be appreciated.
244 7
Numbers: How to increase a column of numbers by a certain percentage I know how to increase individual cells via formula to increase a number by a certain percentage, but is there a way to increase an entire column (as in Excel) to avoid having to type the formula in each cell?
1314 1

1 reply