IF Statement in Excel returns 0, instead of nothing
Posted on 2011-03-21
I have this value in my excel worksheet:
If Excel finds "BD", I get the value in "Sheet1, cell Y34". (Works gret)
If it doesn't find "Fred" I get a 0. (Not what I want)
What I would like it to do is return a blank value, or no value - otherwise I get zeros all over the place - and 1/0/1900 for any date columns.
Is there a better way to check to see if a column contains a string of letters? In my case, I have a sheet filled with values where some start with BD or AD but have different numbers after that. I need to be able to grab just the cells that have a "BD"
I hope that makes sense...