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!

    Hi,

    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
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps?

    In I3

    =IFERROR(IF(ABS(H3)/100<100,H3/100,"NEW"),"NEW")

    and in K3:

    =IFERROR(IF(ABS(J3)/100<100,J3/100,"NEW"),"NEW")


Posting Permissions

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