Hi,
I am facing the problem of diving with zero to calculate growth. However, i know that mathematically its not possible, but in case there is a way it'll be a huge help. The data is in the sample document and if anyone could help with it.
When I calculate growth from FY16-17(=(C3-B3)/B3) and FY17-18(=(D3-C3)/C3) , I get #DIV/0!, Whereas I want 0% for FY16-17 growth and 100% growth for FY17-18.
Please help!!!
Bookmarks