Troy

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

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"

ASKER

didnt work. This is what shows in the cell

#DIV/0!

#DIV/0!

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

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