| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2000 Question
if,then statement returns a false because alpha string is more than 5
characters. Example: =IF(C6="Travel","True","False") and cell 'C6' does equal "travel". It works if "trave" is used in statement and in cell it returns a 'true'. Is this because of a setting in my worksheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) | |||
| Excel 2000 and Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Threaded Mode
