Increasing values by a percentage

Hello, does anyone know how I increase the values in all of the cells in a column by a percentage ? I want to add 0.5% to each of the values in the cells. Many thanks in advance.

Posted on Oct 25, 2021 12:27 PM

Reply
Question marked as Top-ranking reply

Posted on Oct 25, 2021 1:08 PM

If cell B2 has your value you want to increase and cell C2 has the percentage (i.e., the number 0.005 with the cell formatted as a percentage so it displays as 0.5%, or you typed 0.5% into the cell which will do this) then in another cell use the formula

=B2*(1+C2)



3 replies
Sort By: 
Question marked as Top-ranking reply

Oct 25, 2021 1:08 PM in response to harry..1111

If cell B2 has your value you want to increase and cell C2 has the percentage (i.e., the number 0.005 with the cell formatted as a percentage so it displays as 0.5%, or you typed 0.5% into the cell which will do this) then in another cell use the formula

=B2*(1+C2)



Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Increasing values by a percentage

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