Forum Discussion
Bobby_Brown
Nov 04, 2022Copper Contributor
Show percentage changes year over year based on dollars
Need help to create a formula
1 Reply
Sort By
- SnowMan55Bronze Contributor
E.g., if the current year dollar amount is in C2 and the prior year dollar amount is in H2, then the formula would be "=(C2 - H2) / H2" (without the quotes, of course; the spaces are optional). Oh, and then format the cell with the formula as a Percentage.