| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Put the text values in Quotes
ex IF(A1="TEST STRING","TRUE","FALSE") "BarnyardJoe" wrote: I am trying to separate city, state, zip from 1 cell to 3 by using the IF function. But I cannot get the IF function to recognize text values, only numeric. I have already changed the cells format to text, but to no avail. Any suggestions? Can it be done in excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| Excel function help facilities | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Threaded Mode
