troubleshooting Question

Excel 2013 Formulas

Avatar of Troy
TroyFlag for Australia asked on
VB ScriptMicrosoft ExcelMicrosoft Office
4 Comments2 Solutions117 ViewsLast Modified:
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"
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros