Forum Discussion
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.
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.
2 Replies
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.
- 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.
