IF formula and % calculation returns #DIV/0! error

[jayjay123]

Hi Excel gurus,

Can you please help with this? I know there is something wrong with these formulas...
In the yellow cell, I have used this formula. (see below) I know I should be writing "No change" somewhere in the formula but is the IF formula the most appropriate one to use?

Yellow cell (P7)
=IF(O7>0,"Increase","Decrease")

How do I make this +100%
Green cell (Q9)
=O9/N9

I have a blanks within my data set (for example: Row 12). How should I incorporate it so that if there is a blank row, it with return a "blank" cell in P and Q?

Thank you!!

 

[Fluff]

How about

=IF(O7=0,"No change",IF(O7>0,"Increase","Decrease"))

 

[Fluff]

For the 2nd part try

=IF(AND(N2=0,O2<>0),1,IF(AND(N2="",O2=""),"",O2/N2))

 

[jayjay123]

How about

=IF(O7=0,"No change",IF(O7>0,"Increase","Decrease"))

ooh thank you @Fluff!
would you know how to integrate the formula so that I can drag both formulas down (including row 12)? at the moment in the row 12 shows "Increase" (P12) and "100%" (Q12)

 

[Fluff]

If it shows "Increase" in P12 then O12 is not blank.

 

[jayjay123]

Hi @Fluff, sorry not quite sure how to use XL2BB. but please kindly assist! thank you

 

[Fluff]

What exactly is in D11?

 

[jayjay123]

It’s a space

 

[jayjay123]

It’s a space

Or blank cell

 

[Fluff]

Is there a formula in there?