SOS! Formula won't display answer!

Closed
MediaAccountant - Mar 23, 2010 at 10:04 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 23, 2010 at 12:10 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 23, 2010 at 12:10 PM
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
0