Formula help needed to show flyer picture or google drive screen shot picture autmatically

I have a video database sync from google drive. I need a column formula to show if there is a flyer for the column, then show this picture, otherwise, use the Google drive video screen shots picture automatically, can you help with that formula?