Forum Discussion
How to change "#DIV/0!" into 0 in my average data so I can make descriptive statistics.
I have a lot of data with a period of time (monthly from 2019-2021), "speed data", and "stations data". Most of each station has monthly data from 2019-2021, but there is ONE station that only for 20...
Frutank To get rid of any error code, wrap your formula in an IFFERROR statement. Something like this:
=IFERROR(<your formula>,"")This will result in a blank if the formula returns an error. Replace the "" with anything you would want to display in case of an error, for instance, 0 (zero) or "Not applicable".
You mentioned that you are calculating averages. Note the that a series of numbers like 10, 0, 20 will average to 10, whereas 10, blank, 20 will average to 15.
Thank you! It works for me.