Forum Discussion

Copper Contributor

Sep 08, 2020

if statement help needed

I'm trying to discover if the number sequence in column I equal the number sequence in column B. I know they do, but my =if( statement is telling me otherwise. What can I do to fix this? All cells ar...

Formulas and Functions

Copper Contributor

Sep 08, 2020

Thanks, as mentioned in my original message, all cells are set to "general".

Diamond Contributor

Sep 08, 2020

You may apply General to text and number, text will continue to be text and number the number. Perhaps you may submit sample file with couple of records toc heck. Or at least try =ISTEXT() on both.

kristen2020
Copper Contributor
Sep 08, 2020
SergeiBaklan

I'm afraid I don't understand what "toc heck" is. I had tried putting both columns I and B as numbers and then also as text, but that didn't work either, so I kept them both as general. I applied the suggested =istext(), but that only turned my number sequence into "true".

I appreciate you trying to help me through why my statement is failing me.
- Bennadeau
  Iron Contributor
  Sep 08, 2020
  kristen2020
  FYI, "toc heck" is a typo for "to check". 😉
  
  You may be dealing with a trailing space at the end of you number in either column.
  - kristen2020
    Copper Contributor
    Sep 08, 2020
    Bennadeau
    
    ha. Thanks for pointing out the typo. Figured it was something else from excel I knew nothing about 🙂
    
    In regard to a trailing space, you were correct. Column B had that. Appreciate your input! Curious though, I tried =trim(), but that didn't work. I had to go into each cell individually to delete that trailing space. Any thoughts as to why =trim() didn't work?

Resources