Divide by zero error (XP)

Topic

New Reply

I thought this was my fix – it wasn’t – WHY? I don’t get #Div0! anymore, now I get the “name” error

=IF(AVERAGE(C21:C32=0,””),AVERAGE(C21:C32))

Thanks again

Reply | Quote

Replies

One of the closing parentheses is in the wrong place. It should be

=IF(AVERAGE(C21:C32)=0,””,AVERAGE(C21:C32))

although I don’t know if that does what you want.

Reply | Quote

Nope – should have attached the example in the first place – sorry

Reply | Quote

You can use:
=IF(ISERROR(AVERAGE(C3:C14)),””,AVERAGE(C3:C14))
HTH

Reply | Quote

Perfect – I just changed the “” to 0 which is what I wanted in the first place – great thanks.

Reply | Quote

Try

=IF(ISERROR(AVERAGE(C3:C14)),””,AVERAGE(C3:C14))

Reply | Quote

Hi Hans – see my reply to Rory – same for you – great thanks and appreciation, as always.

Reply | Quote