Divide By Zero Error

LeAndre P

Hello,

I was attempting to rid my sheet of the #DIVIDE BY ZERO ERROR and now I am getting the #INCORRECT ARGUMENT returned. What am I missing?

#DIVIDE BY ZERO ERRO Formula

=(AVG(COLLECT([PO Total]:[PO Total], [Order Date]:[Order Date], >=DATE(2021, 12, 1), [Order Date]:[Order Date], <=DATE(2022, 12, 31))))

#INCORRECT ARGUMENT Formula

=IFERROR(AVG(COLLECT([PO Total]:[PO Total], [Order Date]:[Order Date], >=DATE(2021, 12, 1), [Order Date]:[Order Date], <=DATE(2022, 12, 31), 0)))

Thanks in advance,

Genevieve P.

Hi @LeAndre P

It looks like you've just added the 0 portion of the formula after the wrong closing parentheses!

An IFERROR Function works like this:

=IFERROR(Formula, 0)

Notice how it wraps around the entire formula and then you put the 0? Your current formula as the 0 inside of the COLLECT function which is why you're getting an error.

Try this:

=IFERROR(AVG(COLLECT([PO Total]:[PO Total], [Order Date]:[Order Date], >=DATE(2021, 12, 1), [Order Date]:[Order Date], <=DATE(2022, 12, 31))), 0)

Cheers,

Genevieve