On Jan 13, 10:04*am, vbrush wrote:
Sales person closing at 60% for November and 42%
for December... What is the % change(slippage, in
this case)...not the % change of basis points...in
this case 18% points.

"What is the % change" of what? Customers? Closed sales?

In either case, you cannot determine it from the sales closing ratio
alone. Consider these examples:

Customers: 100 Closed Sales: 42 Ratio: 42%
Customers: 200 Closed Sales: 120 Ratio: 60%
Customers: 400 Closed Sales: 168 Ratio: 42%

Note that the lower sales ratio could arise from either an increase or
a decrease in customers and/or closed sales.

Suppose you want to compute the percentage change in closed sales. If
the Dec number of closed sales is in B2 and the Nov number is in B1,
the percentage change is B2/B1 - 1, formatted as Percentage.