SOS! Formula won't display answer!

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
may be where you pasted this formula is formatted as text. So instead of formula, it is considering it as text. You can try there =today() to see if you get formula back or get the date