Hi I'm trying to get a formula to return a "Yes" if reference cell is greater than 8 and "No" if less than 8, but to return a blank if the reference cell is also blank. As of right now it's returning a "Yes." I'm sure it's a straightforward answer but I have been searching online and trying different things for a couple hours to no avail.

Thanks so much in advance for the help.