divide by zero errors

**AllenMead** · 09-23-2010, 01:42 AM

ok, I have the following formulas which are giving me a divide by zero error;

(All 5 formulas are Arrays confirmed with { })

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any help would be much appreciated.

**zbor** · 09-23-2010, 01:54 AM

Can you upload example workbook?

avoid important data, but leave the form.

**AllenMead** · 09-23-2010, 02:27 AM

Ok, uploaded the sheet.

The divided by zero errors are in the sheets that have a green tab at the bottom.

**royUK** · 09-23-2010, 03:24 AM

I edited this title earlier for you to remove unnecessary wording. Re-edit before i close it

**AllenMead** · 09-23-2010, 03:38 AM

Apologies, my bad.

**royUK** · 09-23-2010, 03:56 AM

Thanks for taking the time to read and comply with the rule

.

**AllenMead** · 09-23-2010, 06:01 AM

Solved, removed the averageif statement as I had this answered in another way

Re: divide by zero errors