=IF(AND(ISTEXT(A2),ISTEXT(B2),ISTEXT(C2),ISTEXT(D2 )),1,0)

Hope this helps.
--
John C


"sed" wrote:

A B C D
E
1 Name Age Country Last Name

2 Sed 22 USA Doe

3 Mike 37 UK Dane

My question is this... How can I get cell E1 to turn into a 1 in the case
that if and only if there is text in cells a2, b2, c2, d2... if one of them
doesnt have text it has to become a 0.
Appreciate the help!



--
sss