#NUM!

[JOEE1979]

I have a formula in a cell, the formula works great.
Sometimes the formula shows "#NUM!" (I'm ok with that, at certain times it needs to happen).
Is there a way instead of showing "#NUM!", I can have it show "Tomorrow"?
I have played around with conditional formatting, but it only lets me change the color of the box and font, but not the wording.

FYI,,, the formula is =SMALL(G8:G1048576,COUNTIF(G8:G1048576,"<"&$B$1)+G5)

Thanks

 

[RoryA]

You could use IFERROR:

=IFERROR(SMALL(G8:G1048576,COUNTIF(G8:G1048576,"<"&$B$1)+G5),"Tomorrow")