Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address

The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.

You can make a difference in the Apple Support Community!

When you sign up with your Apple ID, 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 Best 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

Percentage change

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