=IF(OR(ISBLANK(D2),ISBLANK(H2))=1,0,IF(H2=D2,0,1))
I am trying to return a 0 if either cells are blank, or if they are both filled in, but equal. I wish to return a 1 if both cells are full, but unequal. Examples would be: EA, BX, PR, et cetera. Thanks!
perhaps this...
=IF(OR(D2="",H2="",D2=H2),0,1)
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
This worked! Thanks a mil.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks