Previous Topic Next Topic

SOS! Formula won't display answer!

Closed
MediaAccountant - Mar 23, 2010 at 10:04 AM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

WhatsApp Bluetooth calls issue
Sleek -
hransheed -

8 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Computer turns on but no display
Lancenz -
Lancenz -

2 responses