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
Bookmarks