Show percentage changes year over year based on dollars

Copper Contributor

Need help to create a formula

1 Reply

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.