Comparing percentages

D

David Biddulph

You're probably going to need to define what you mean by "overage" and
"slippage".
 
V

vbrush

Thank you-
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.
 
J

joeu2004

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.
Click to expand...

"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.
 
D

David Biddulph

If you are trying to ask how to get 18% as the difference between 60% and
42%, the answer is =A3-A2, if those are the cells with the data. Format the
result as a percentage.
 
Top