need to hide "div/0!"

  • Thread starter Thread starter Jontie
  • Start date Start date
J

Jontie

I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))
 
You could have something like:

=IF(COUNT(N6:N100)=0,"",your_formula)

Hope this helps.

Pete
 
=IF(COUNT(A6:A12)=0,"",AVERAGE(A6:A12))

Regards,
Stefi

,,Jontie" ezt írta:




- Show quoted text -
Click to expand...

Stefi thanks for it but when i put this formula in the cell it gave me
number in decimal place where real it should have given me 30 but the
answer was way too off the scale
 
I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))
Click to expand...


Try this instead:

=IF(SUM(N6:N100)=0,"",AVERAGE(N6:N100))

entered as a normal formula
--ron
 
I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))
Click to expand...


Sorry, that should have been:

=IF(COUNT(N6:N100)=0,"",AVERAGE(N6:N100))


--ron
 
Sorry, that should have been:

=IF(COUNT(N6:N100)=0,"",AVERAGE(N6:N100))

--ron
Click to expand...

..3368 is the answer i m getting after using the above formula where as
it should be 32
 
.3368 is the answer i m getting after using the above formula where as
it should be 32
Click to expand...

Then there is a problem with your interpretation of your data.

Place the following formulas on your worksheet and tell me what the results
are:

=AVERAGE(N6:N100)
=COUNT(N6:N100)
=SUM(N6:N100)


--ron
 
Then there is a problem with your interpretation of your data.

Place the following formulas on your worksheet and tell me what the results
are:

=AVERAGE(N6:N100)
=COUNT(N6:N100)
=SUM(N6:N100)

--ron
Click to expand...



thank you for your help and that was a mistake on my part. sorry you
were right.

thanks for everyone who answered my questions and my template is now
processing and soon will be avaliable to download on the "microsoft
office online" under excel templates . :) :) :) with a name of
"Short Term Stock Investments
"
 
thank you for your help and that was a mistake on my part. sorry you
were right.

thanks for everyone who answered my questions and my template is now
processing and soon will be avaliable to download on the "microsoft
office online" under excel templates . :) :) :) with a name of
"Short Term Stock Investments
"
Click to expand...

Glad you got it worked out. Thanks for the feedback.
--ron
 
Back
Top