raven_squire
Board Regular
- Joined
- Jan 13, 2013
- Messages
- 99
Hello,
I have a table that is populated by a macro from a log file. I have a column in the table that compares the value in a column and returns true or false =IF([@[Truck number]] = "unknown",TRUE,FALSE). Problem is that this is always returning false.
I have tried similar (simple IF) formulars on different columns and some work and others don't. All the values in columns come from the same txt file and the number type of the cells is always "General". Data in the columns is generally text or text and numbers. I have evaluated the formulars and it seams that "Apples" does not = "Apples"
What am I missing?
I have a table that is populated by a macro from a log file. I have a column in the table that compares the value in a column and returns true or false =IF([@[Truck number]] = "unknown",TRUE,FALSE). Problem is that this is always returning false.
I have tried similar (simple IF) formulars on different columns and some work and others don't. All the values in columns come from the same txt file and the number type of the cells is always "General". Data in the columns is generally text or text and numbers. I have evaluated the formulars and it seams that "Apples" does not = "Apples"
What am I missing?