Need Excel Formula for Comparing Weekly Sales Variations Accounting for Small Base Values

Hello,

I am in need of assistance with creating an Excel formula to compare weekly sales variations across different sales points. The main challenge is to account for variations originating from very small base numbers, which can skew the analysis.

Key Requirements:

Handling Small Base Numbers: The formula should be able to adjust for cases where the initial sales figures are very low, to prevent misleadingly high percentage increases.
Comparative Analysis: I need to compare weekly sales changes in a way that is fair and accurate across all sales points, regardless of their initial sales volume.
Simple and Effective: The solution should be straightforward to implement in Excel without requiring complex statistical knowledge.
The aim is to have a reliable and clear method for assessing week-over-week sales performance that can be used for regular reporting and analysis. Any guidance on setting up this formula in Excel would be greatly appreciated.

Thank you for your help.

Best regards,