ExcelBanter - Percent increase in excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Percent increase in excel (https://www.excelbanter.com/new-users-excel/14121-percent-increase-excel.html)

Aiko

Percent increase in excel

How could a I do a percent increase when I have two tables with money values,
one from last year and one from this year?

Jock W

For each line, enter:
=((last year-this year)/this year)*100
eg: =((G7-F7)/F7)*100

"Aiko" wrote:

How could a I do a percent increase when I have two tables with money values,
one from last year and one from this year?

All times are GMT +1. The time now is 06:57 AM.