Forum Discussion

kristen2020

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

SergeiBaklan

Diamond Contributor

Sep 08, 2020

kristen2020

One could be text, another number, not clear from the screenshot. If so, keep in same format or convert when compare.

kristen2020
Copper Contributor
Sep 08, 2020
SergeiBaklan

Thanks, as mentioned in my original message, all cells are set to "general".
- SergeiBaklan
  Diamond Contributor
  Sep 08, 2020
  kristen2020
  
  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.