Excel Formulas

[jasbol]

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 · Accepted solution]

@jasbol 

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.

[#3]

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.