Percentage Difference and Decreasing Percentage

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)

Many thanks in advance.

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")