HeavyMusic
New Member
- Joined
- Apr 15, 2022
- Messages
- 1
- Office Version
- 2011
- Platform
- Windows
Hi,
I have two columns in my worksheet. In the cells, it has a text of "6-62" and converted into number is 22798. Other text cells are 12345 and converted to numbers are 12345. I am trying to do a if statement or text function to isolate the "6-62". If I do the if statement to say if 6-62 = 22798, say YES otherwise NO. It always says Yes. Using the text function, It shows that "6-62 and 22798 are not equal. But it also gives me the same for the text 12345 that in number format 12345 are not equal. Again , just trying to isolate where the text 6-62 is different that the converted text to number result of 22798. Thanks
I have two columns in my worksheet. In the cells, it has a text of "6-62" and converted into number is 22798. Other text cells are 12345 and converted to numbers are 12345. I am trying to do a if statement or text function to isolate the "6-62". If I do the if statement to say if 6-62 = 22798, say YES otherwise NO. It always says Yes. Using the text function, It shows that "6-62 and 22798 are not equal. But it also gives me the same for the text 12345 that in number format 12345 are not equal. Again , just trying to isolate where the text 6-62 is different that the converted text to number result of 22798. Thanks