If 'Prime Time' then a specific value should be returned, otherwise another value should be returned. Now if you do not put the FALSE action in, and the condition check returns false, then the result of your IF function will display FALSE. I have been trying, unsuccessfully, to use the IF statement to check a date range and confirm whether the cell is 'Prime Time' or not 'Prime Time'.
So in order to build your IF statement, you would build it like another other if statement, you would just need to include the sheet name with the. So if we want to reference A1 on another sheet we use: another sheetA1. you need to include the sheet name in front of it. In order to reference a cell on another sheet, instead of using: =A1 in order to reference a cell on another sheet, instead of using: A1.