I want to consider 4 scenarios in google sheets. All deal with a periodic return over
- Positive to Positive
- Positive to Negative
- Negative to Negative
- Negative to Positive
For instance EPS in 2010 was \$1 and EPS in 2020 was \$3. How to best calculate the annual return between these data points?
I tried this in Excel
This formula breaks when I am changing either number to negative.
What can I do to fix it? Is there a grateful way to do it in Excel?