I have data that is imported in which I have a simple IF formula created...=IF(OR(A2>=2,B2>1,C2>1),"Yes","No"). The data in these cells must have blanks in them that is causing the formula to display Yes when there are no numbers in the referenced cells. Does anyone have a way of getting rid of the blanks?
I have read about Trim but that does work. I need help. Thanks.
Josh
Please Login or Register to view this content.
That worked rcm! Can you explain a little bit about your formula vs mine? Thanks.
Josh
theres a character (zero length) in column C - not a blank - although isblank() returns false and if you clear the column it resolves the issue
highlight the cells -right click and clear contents works
i tried cellview to see hidden character but did not find any
Last edited by etaf; 04-21-2013 at 04:17 PM.
Yeah, there's something in those cells.
I ran this macro on the cells and it removed whatever was in there and the formulas now return the expected results.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks etaf!
My formula checks for non-empty cells (a2<>"") before acting on them
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks