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.

Percentage change

I have a column of figures to which I would like to add the same percentage increase/decrease to each individual line, about 140 lines in total, in the following column! Rather than manually alter each line by the same percentage I believe it is possible to have a formula that would do this by reference to just one cell in which is the current percentage figure required, and just by altering this one cell would update all the figures in the column. Help please.

MacBook Pro 16″, macOS 12.3

Posted on May 15, 2022 5:09 AM

Reply
Question marked as Top-ranking reply

Posted on May 15, 2022 6:33 AM

Just write the normal formula

C2=A2*C2 (multiplying the content of cell A1 with the content of C2)

Then select the triangle for C2


Now select Preserve Row and hit return.


Now copy this formula to all your cells (autofill).


Now all calculations will be based on C2



Hope that will help


Ralf

2 replies
Question marked as Top-ranking reply

May 15, 2022 6:33 AM in response to chrisfeast

Just write the normal formula

C2=A2*C2 (multiplying the content of cell A1 with the content of C2)

Then select the triangle for C2


Now select Preserve Row and hit return.


Now copy this formula to all your cells (autofill).


Now all calculations will be based on C2



Hope that will help


Ralf

Percentage change

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.