 SOLVED

Highlighted

# Calculating percentages

I'm sure this is a very simple answer, I just cant figure it out. I need to know how to make a column show percentages of the adjacent columns figure to a specific cell. For example; The single cell shows total sales figure, and the column shows expenses by category. How do I make a column next to expenses that show their percentage of total sales without having to change the formula in each cell in the column?

4 Replies
Highlighted
Solution

# Re: Calculating percentages

Use absolute row reference for the total sales. If your expenses are in A2:A9 and your total sales in D1, your formula in B2, copied down to B9 is:
=A2/D\$1
Format B2:B9 as Percentage.
Highlighted

Awesome, Thanks!

Highlighted

# Re: Calculating percentages

Remember this tip:
If you copy the formula down rows, lock the row by inserting a dollar (\$) sign before the row number.
Conversely, lock the column by inserting a dollar (\$) sign before the column number, if you copy across columns.
Succinctly stated:
Copy down rows? Lock row number
Copy across columns? Lock column letter
Highlighted

# Re: Calculating percentages

Trying to calculate % decrease between two cells (2019 revenue vs. 2020 forecasted revenue, as a percentage). Spacing this simple formula.... thanks!