Hey,
I got a problem with the formula that I am trying to produce. The end result is supposed to look something like this:

xxxx is starting soon on channel yyyy (ex. Family Guy is starting soon on channel 48)
or
xxxx is now playing on channel yyyy (ex. Family Guy is now playing on channel 48)
or
""

What I already have is different columns for which TV show, the channel, if it is playing soon, and another for if it is playing or not. What I need to do is put that all together and come out with either of those 3 statements.

Thanks,
WondersAlo
...if you do not understand let me know what you do not understand I will rephrase