Divide by zero error again!

**AllenMead** · 10-31-2010, 11:38 AM

I have the following formula where column CL remains blank until I populate it, however, the following formula gives a divide by zero error with blank cells.

The other issues is that column C may not always contain the text CPHA

Please Login or Register  to view this content.

Any help would be much appreciated! (Pulling my hair out on this one!)

**zbor** · 10-31-2010, 11:46 AM

Edit: Deleted

**DonkeyOte** · 10-31-2010, 11:47 AM

Not a duplicate zbor... the questions though similar are different.

Per the point I made in the thread above I'd reiterate that the formula you have won't work regardless - the inline array will not perform as I think you expect it will.

If you need to handle #DIV/0! then use IFERROR.

The correct version account for inline array would be:

Please Login or Register  to view this content.

**AllenMead** · 10-31-2010, 11:50 AM

true, but this is slightly different in that with the first reference colunm CL is numerical, which would works ok, but, how do I resolve the secondary, where column C may not always contain CPHA nut is always populated, no blanks.