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