Removing Div#/0 from with Function check

[Hawkeye]

Hello,

I have a Spreadsheet that is doing daily treatment event calculations with each sheet being a separate month. However I have set it so that on weekends where there is no treatment there is no costing added but the calculation of number to treat is still present but end up with a Div#/0 error on a function [=AS29/AVERAGE(AS6:AS23)]. If there is no treatments then Average(AS6:AS23) = 0 and then there is a Div#/0 error.

I have tried the IF function suggested by the error tracker:

=IF(AVERAGE(AS6:A23)=0,"",AS29/AVERAGE(AS6:AS23))

But this still gives a Div#/0 error. ANy ideas to get rid of the Div#/0 error as it subsequently buggers up a SUM formula for the month afterwards.

Cheers Hawkeye

Using Excel 2008 on a Mac (ie no VBA macros possible)

[ratcat]

G'day and welcome to the forum,

Try this

Please Login or Register  to view this content.

HTH

[Teethless mama]

=if(count(as6:as23),as29/average(as6:as23),"")

[Hawkeye]

G'day and welcome to the forum,

Try this

Please Login or Register  to view this content.

HTH

Worked like a charm!

Thanks RATCAT....going to look up "ISERR" function now.

Cheers Hawkeye