| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement return wrong comparison
I have a If statement in L95 as follows: IF(L95="District Did Not Investigate" and L95 contains this statement It returns a FALSE answer when the answer should be TRUE. WHY?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement return wrong comparison
On Wednesday, 3 June 2015 23:40:42 UTC+10, Don B wrote:
I have a If statement in L95 as follows: IF(L95="District Did Not Investigate" and L95 contains this statement It returns a FALSE answer when the answer should be TRUE. WHY? Most likely there's an extra space in the text in L95 or a change of case somewhere. One way to get around this would be to change your formula to start =IF(TRIM(UPPER(L95))="DISTRICT DID NOT INVESTIGATE" ... That should give the right result whether or not there are extra spaces around the text or the case is incorrect. Howard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm trying to do a comparison if statement but it is not working!! | Excel Programming | |||
| wts wrong with this statement | Excel Worksheet Functions | |||
| HELP: Comparison IF statement | Excel Worksheet Functions | |||
| Date Comparison and IF statement | Excel Worksheet Functions | |||
| Comparison Operators for IF statement. | Excel Worksheet Functions | |||
![Don B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
