You can use Excel to calculate percentage increases or decreases to track your business results each month.
Let’s first start by inputting our initial data. We’ll be using monthly expenses for this example. Let’s say you anticipate that next year’s costs will be 5% higher, so you want to see what they are.
Below the cells, in the first cell type the name of the calculation: Up by 5%. This is only for reading purposes so this text can be anything you’d like. Now to the actual calculation. In the cell next to it type the total cell * 105% and press enter. That’s the result of 5% growth.
For the decrease formula, all you need to do is the opposite of adding the 5% to 100. The formula then will be * 95%. Press enter when done.
As you can tell Excel makes your life a lot easier when it comes to percentages!
What other tutorials would you like us to make? Let us know in the comments below.
#HowTech #Excel #Percentages
All our announcements are available here https://t.me/howtechtv
Commercial questions [email protected]
Take the opportunity to connect and share this video with your friends and family if you find it useful.