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"
Open in new window(assuming you have that column formatted as a percentage and 1 is 100%. If not change the 1 to 100)