asked on Excel 2013 Formulas
I would like to calculate % change from last year in column I and need some help with the formula.
Here is my excel table
![Excel.JPG]()
Here is my formula that i have in cell I6.
=(D6-H6)/D6
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"
Here is my excel table
Here is my formula that i have in cell I6.
=(D6-H6)/D6
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"
VB ScriptMicrosoft ExcelMicrosoft Office
Last Comment
Flyster
ASKER
didnt work. This is what shows in the cell
#DIV/0!
#DIV/0!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Open in new window
(assuming you have that column formatted as a percentage and 1 is 100%. If not change the 1 to 100)»bp