A lending desk recorded 100 bookings in its baseline week. The next week rose to 144, and the following week stayed at 144. If a weekly summary needs one constant rate over those two changes, find the rate that takes 100 to 144 in two equal steps.
Turn each weekly change into a multiplier
Enter 44% in B2 and 0% in B3. In C2 enter =1+B2 and fill down. This gives 1.44 and 1.00. A 10% drop would enter the calculation as 0.90.

Illustrated factor setup. Use one factor per period of the same length.
Apply the result twice to the starting amount
=GEOMEAN(C2:C3)-1Format the result as a percentage. It should read 20%. Starting with 100, multiply by 1.20 to get 120, then by 1.20 again to get 144. Use that reconstructed ending value as the check on your sheet.

Illustrated check. The ending values agree, even though the intermediate values differ.
Keep the calculation to positive multipliers for equal-length periods. A row with no observation needs to stay flagged until you can determine its change. Entering a zero-percent change would assert that you saw a flat week.



