It creates a reusable function that takes three inputs: actual sales, sales quota, and a weighting factor. It returns a ...

You’ll find it under the Formulas tab, in the Formula Auditing group. Once you open it, just hit Add Watch and select the cells you want to monitor. The pop-up will show you the sheet name, cell ...