View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Comparing percentages

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.
--
David Biddulph

vbrush wrote:
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.

"David Biddulph" wrote:

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

"vbrush" wrote in message
...
How do i compare the overage/slippage of one percent vs another?