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!!

 

[jayjay123]

O

Is there a formula in there?

Oh yes. Sorry..it will be dragged down formula from above

 

[Fluff]

What is the formula?

 

[jayjay123]

O12 formula

=N12-M12

 

[Fluff]

Well that is neither blank nor does it contain a space, it will return a number.
Also it does not help when you keep changing the column references.
Based on the images in post#6 if that formula is in D12 then it does not return 0 but a positive number.