How to Create a Percentage Increase Formula

In this Excel Training video, we’ll show you how to create a dynamic percentage increase or decrease formula. This versatile formula calculates the percentage change between two values, providing you with a powerful tool for analyzing data trends, financial performance, or any scenario where understanding relative change is essential.

Whether you’re a seasoned Excel user or just beginning your spreadsheet journey, mastering this formula is a fundamental skill that empowers you to make data-driven decisions with confidence. Join us as we guide you through the step-by-step process.


Percentage increase/decrease formula:

=(B2 - A2) / A2

info Important: change “A2” with the cell where your initial value exists in your worksheet. And change “B2” with the cell where your final value exists.

John Gleave

John Gleave has been a researcher, content writer, and senior editor at Business Tech Planet since 2022. John was formerly a data analyst and web designer with expertise in several programming languages, such as JavaScript, JQuery, PHP, CSS, SQL, and more! With a passion for writing and technology, he has now focused his skills on crafting tech guides for BTP. You can connect with John on LinkedIn.

Recent Posts