This year revenue is in B2, last year in C2. Return YoY percent growth

公式

=(B2-C2)/C2

说明

YoY growth is (new − old) / old. Format as Percentage. Guard divide-by-zero when last year is 0 or blank.

步骤

  1. Subtract last year from this year.
  2. Divide by last year.
  3. Format as %.

变体

Zero-safe

If last year is 0 and this year is not, treat as 100% new; both 0 → 0%.

=IF(C2=0, IF(B2=0, 0, 1), (B2-C2)/C2)

From a date column (365)

Pull last calendar year’s total when you store one row per day.

=SUMIFS(B:B, A:A, ">="&DATE(YEAR(TODAY())-1,1,1), A:A, "<="&DATE(YEAR(TODAY())-1,12,31))

CAGR over n years

Five-year compound annual growth if C2 is the start value.

=(B2/C2)^(1/5)-1