I'll show you the basic usage of IF function in Google Drive Spreadsheet. The IF function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.
You probably seen video where clips are playing in a title text and made you wondered how the heck to they do that. Well it's pretty easy to create the video in text effect with Adobe Premiere.