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!
Related:

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
0

Similar discussions

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

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

2 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
No display on monitor, light blinks
Harsh20_4 -
Anonymous -

9 responses