Link to home
Create AccountLog in
Avatar of Troy
TroyFlag for Australia

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

User generated image
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"
Avatar of Bill Prew
Bill Prew

Try this:

=IF(ISBLANK(D6),1,(D6-H6)/D6)

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
Avatar of Troy

ASKER

didnt work. This is what shows in the cell

#DIV/0!
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account