RowRowRowYourBoat
New Member
- Joined
- Aug 20, 2015
- Messages
- 5
Hi guys,
Looking for some help on a formula to analyze percentage trend over three years. I have three sets of values 2016, 2017, 2018. and I would like to see the percentage year over year. When i try this formula - =AVERAGE((U2/S2-1),(W2/U2-1)) some work and some don't because i have some cells with zero value. i tried to use the averageif, but that didn't work either!
Appreciate your help
Jamie
Looking for some help on a formula to analyze percentage trend over three years. I have three sets of values 2016, 2017, 2018. and I would like to see the percentage year over year. When i try this formula - =AVERAGE((U2/S2-1),(W2/U2-1)) some work and some don't because i have some cells with zero value. i tried to use the averageif, but that didn't work either!
Appreciate your help

Jamie