I'm trying to use a IF function for something as simple as "=IF(C3=40,"YES',"NO)" then it returns "NO"... the cell clearly has 40 and the formatting is general. The data is from an embedded query.
When I type the function as "=IF(C3="40","YES","NO"), then it returns "YES" like I want.
I'm looking to ultimately use greater than or less than functions with the IF function, but it doesn't work because of how the data is stored. Thank you for your help!
Bookmarks