Results 1 to 2 of 2

Thread: Percentage Difference and Decreasing Percentage

  1. #1

    Percentage Difference and Decreasing Percentage

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I am working on a table and have a couple of questions. As this is a long list of Products with a number of products not sold in either 2013 or 2014 thus being "0'' is this the right formula to use? Also is there a way to reduce the percentage from -267% to the actual -72.7% that it should actually be?

    I would like 2 formulas that I could use to get the results in Grey (Sold WANT and RATE DIF WANT)
    Click image for larger version. 

Name:	New Picture.jpg 
Views:	8 
Size:	71.2 KB 
ID:	3022
    Many thanks in advance.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016

    In I3


    and in K3:


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts