Nov 04 2022 01:02 PM - edited Nov 04 2022 01:03 PM
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.