I have an IF formulae checking a column of numbers and returning either a word or blank depending on true or false.
However the formulae takes a blank cell as true, I don't want this!
Would like the formulae to ignore all blanks if possible.
Any ideas?
What is the formula you using now?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Maybe something like this?
=IF(A2="","",your-formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
try this
I know that may look a little weird, but without seeing your IF statement I can only fake it....
Please Login or Register to view this content.
HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Well the if statement already looks like this!
=IF(AND(COUNTIF($C$8:$C$600,C8)=2,C8>=$I$5,D8<=$I$6),"in",IF(AND(COUNTIF($C$8:$C$600,C8)=3,C8>=$J$5,D8<=$J$6),"in",""))
So I'm trying to get it to avoid data that doesn't have numbers is it classes it as true
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks