Formula: Division by Zero or Negavite Number

Good Morning,

I'm working on modifying an existing spreadsheet that have some simple formulas. The two main conditions I need to add to the formula are for handling a divisor of zero or a negative number. You'll see that the initial formulas that were created are for numbers that are exclusively "greater than" or "equal to" zero.

I can't imagine it's too complicated but I've given it my all for a day now. It'll probably be an "oh duh" moment. At least I hope so.

The columns with the formulas are D, F, G, H. D is kind-of the anchor in that it's pulls an average from L:N that has to be greater than zero. All other formulas build from there.

You'll also see that when "E" is negative the remaining formulas won't produce a result.

Any help would greatly be appreciated. Any additional explaining I need to do please ask.

Thanks,
Jason

Thanks Alan, That would probably help. Lol.

If D is zero, I would like G to show a zero (to represent no increase), and H to show "fail".

If E is negative, I'd like F and G to be zero (to show no increase), and H to show "fail".

I hope that make sense.

Hi,

That worked great. I really appreciate it.

It looks like I have one more issue to solve. And that is to ammend the formula in H.

I've attached the document so you can see the instances where it leaves H blank and I'd like it to populate "FAIL" because there is no increase (represented by either F or G).

I hope I explained that correctly. That where there is zero increase, represented by either F or G, I'd like H to populate "FAIL".

2013-11 RUNNING PROJECTIONS for forum.xlsx

Perfect!

Thanks so much for helping today. I'm excited this is working great!

-Jason