Forum Discussion
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...
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.
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?
Thank you for clarifying that. I'll keep this in my back pocket in case I need to use it down the line. Appreciate you helping out!
