Formula's Showing in Cell when Cell is Blank

[chad328]

G'day Members,

I have a sheet I use for greyhound racing that contains formula's that retrieve data from downloaded tabs on the same sheet,
When the those tabs contain no information for one reason or another, the result cell will show the formula instead of a blank cell.

I've attached an example sheet where you will see what I am referring to in the "Time Section" & the section below it

Any pointers would be much appreciated.

Regards,
Chad

[Sam Capricci]

the file you uploaded doesn't contain a Dog 9 tab. So the formula in N23 is returning the formula in V10. I don't believe an IFERROR added to a formula will account for a missing tab. If you delete the formula in V10 the formula in N23 will return blank. If you change the reference in the formula in V10 from Dog 9 to Dog 8 the formula works fine.

[chad328]

Thanks Sam, Much appreciated mate, Rep being submitted

[MarvinP]

Hey Chad,

Change the formula in V10 to equal to zero instead of "".
=IFERROR(AGGREGATE(15,6,'Dog 9'!$K$2:$K$300/('Dog 9'!$D$2:$D$300=$E$13&"m"),ROWS(V$10:V10)),0)
Then pull this new formula down and to the right.

That will make those other formula look a lot better. See attached at:
V10 error to zero and not blank.xlsm

[Sam Capricci]

Interesting, so changing from "" to 0 in the IFERROR will overcome a missing tab. Didn't try that. Learned something new, thanks Marvin.

[chad328]

Hey Chad,

Change the formula in V10 to equal to zero instead of "".
=IFERROR(AGGREGATE(15,6,'Dog 9'!$K$2:$K$300/('Dog 9'!$D$2:$D$300=$E$13&"m"),ROWS(V$10:V10)),0)
Then pull this new formula down and to the right.

That will make those other formula look a lot better. See attached at:
Attachment 678710

Marvin,

Thanks a heap mate,
LOVE this place, learning more & more,
Excel blows my mind, as does the wisdom & guidance from you guys.

Reps added

Kind regards,
Chad