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 01: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
345 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.
312 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?
1671 1

1 reply