if statement help needed

Question

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 are set to "general".

Thanks in advance.

sergeibaklan · Answer

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

kristen2020 · Answer

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

sergeibaklan · Answer

kristen2020&nbsp;
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 · Answer

SergeiBaklan&nbsp;&nbsp;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".&nbsp;&nbsp;I appreciate you trying to help me through why my statement is failing me.

bennadeau · Answer

kristen2020&nbsp;FYI, "toc heck" is a typo for "to check". 😉&nbsp;You may be dealing with a trailing space at the end of you number in either column.&nbsp;

Forum Discussion

if statement help needed

8 Replies

Resources