SOLVED

# Excel Formulas

Copper Contributor

# Excel Formulas

Hey Team,

I am creating an excel sheet using CY Sales and PY Sales.  I want to show the YoY % Increase or Decrease.  The problem I'm having is some PY Sales were \$0.  What is the best way for me to show this?

Because if the \$0 value, I am obviously getting the #DIV/0! error.

2 Replies
best response confirmed by jasbol (Copper Contributor)
Solution

# Re: Excel Formulas

Mathematically, the increase is infinitely large, so it's probably best to do something like

=IFERROR((CY-PY)/PY, "New Entry")

or use some other text. You might arbitrarily set the increase at 100%, but that is unsatisfactory, because then both 0 to 2000 and 1000 to 2000 would return 100% as increase, while 500 to 2000 would return 300% increase.

# Re: Excel Formulas

Thank you, Hans,
I appreciate the response. I think I am just stuck with the huge YOY% number. I was hoping someone had a magic answer on how to make it look better.
1 best response

Accepted Solutions
best response confirmed by jasbol (Copper Contributor)
Solution

# Re: Excel Formulas

Mathematically, the increase is infinitely large, so it's probably best to do something like

=IFERROR((CY-PY)/PY, "New Entry")

or use some other text. You might arbitrarily set the increase at 100%, but that is unsatisfactory, because then both 0 to 2000 and 1000 to 2000 would return 100% as increase, while 500 to 2000 would return 300% increase.