I would like to calculate % change from last year in column I and need some help with the formula.
Here is my excel table
Here is my formula that i have in cell I6.
How can i make it that if cell D6 is blank then the default value in Column I cell I6 is 100%
All cell format types are set to "Accounting"