Hide the Div/0 error?

Hi guys,

Got a slight problem with one of my spreadsheets.
I'm populating a spreadsheet with data about our internet speed. The tests are conducted hourly on each day, and to the side of this data I have a summary area where I've set up three cells to display the slowest, fasted and average speed of each day. However, when there is no data in the field I recieve the #Div/0!.
I'm not sure if i can use forumula considering it's already in each cell, and each cell uses conditional formatting also.

Any help is appreciated.

Thanks, I'm aware of the formula that can be used, but is this possible considering the cells contain formula to display the highest, lowest and average download speeds.
They're also subject to conditional formatting to differentiate between speeds.

Attatched, to the right of the Upload Speed, there are 3 coloured cells that each contain the error. Note that they each contain formula and conditional formatting.

Thanks. The cell being left blank is fine so I'd use " " within the formula. But if you notice on the cells where data is present, you still receive the green marker in the corner (top left of cell). Any idea why this happens?

Originally Posted by Søren Larsen

You should rather use "" in the =IFERROR() formula instead of " ".

With regards to the "green marker", it does not appear because of the =IFERROR(); you will notice that if you select any cell with the =AVERAGE() calculation (and without =IFERROR()) and hit F2 and then Enter, the "green marker" also appears. It appears because Excel is telling you that there are values next to the range on which you are calculating the average that are not included in said range. Obviously in your case this is not a mistake, but Excel does not know that.

Oh right, so it's more of a notification that I've potentially missed cells from a calculation, rather than a notification telling me I've got an error with my formula.