How can I get 1,1,0 if I have string, string, blank

[guybrown]

If I have text strings in A1 and B1 and C1 is blank, how can I get an array of 1,1,0?

eg. cat, dog, [blank]
{=--(cat, dog, [blank])} ???

[NBVC]

Not sure what you are trying to ultimately achieve... Are you putting this in a larger formula ?


ISTEXT(A1:C1)

check if cell has text or not.. returns TRUE or FALSE the -- will convert to 1 and 0,

[jeffreybrown]

Please take a few minutes and read the Forum Rules about cross posts.

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.

It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post

[guybrown]

Cross posts:
http://www.mrexcel.com/forum/showthr...=1#post2776570
and related larger problem:
http://www.mrexcel.com/forum/showthread.php?t=561916

[guybrown]

Not sure what you are trying to ultimately achieve... Are you putting this in a larger formula ?

Thanks, that's great!