u/People-Want-Ducks

I have a weird situation I'm trying to work out here, and it's more of a logic exercise that I'm trying to fix rather than a necessity.

But I'm looking at a podcast's list of episodes and how the episode numbers work, guest lists, bonus episodes, etc., and I'm wondering how I would make this work.

Assume I have the following, with

Episode	Guest	Organisation	Episode Title
8	Steve	Apple	Episode 8: Steve – Apple
9	Tim		Episode 9: Tim
Bonus Episode 3	Bill	Microsoft	Bonus Episode 3: Bill – Microsoft
Bonus Episode 4	Bob		Bonus Episode 4: Bob

The idea here would be that, if an episode has an organisation attached to it, the title will return the organisation name after the episode number and the guest's name, but if there is no organisation, then it will simply say the episode number and the guest's name.

It's much the same for the bonus episodes, though the difference is that it will now include the word 'Bonus' before the episode name.

I'm assuming some sort of formula including following would work for the regular episodes

=IF(C2<>"", ("Episode "&A1&": "&B2&" – "&C2), ("Episode "&A2&": "&B2))

But how would I then incorporate the 'Bonus Episode' part into it?

I figured something that incorporates the following, but I can't quite swing it:

=IF(LEFT(A3,3)="BON")

How could I go about making this work?