I have a huge spreadsheet I need to sort by media type. The only way I can think of doing this is to do an IF formula that will display either "TV", "RADIO", or "PRINT" using the call letters like "W D M O - TV". I have gotten this formula off of Microsoft's website: =IF(ISNUMBER(SEARCH("FM",D4))),"RADIO",IF(ISNUMBER(SEARCH("TV",D4)),"TV","PRINT")
but when I typed it in the excel spreadsheet it just displays the formula not the answer. It doesn't even display an error message just the formula. I don't know if I have it wrong but I need help, quick!