Function AND

[Guest]

I have excell 2002, in the explantion of function AND it says, that Logical1,
logical2, upto logical 30, how ever mine is available for only logical5,
(upto 5 logical). Can anybody help me how to make it upto 10 logical

Frank

 

[Guest]

You may have to have a User Defined Function to do that. Take a look at
this and come back if you have more questions.

http://www.vertex42.com/ExcelArticles/user-defined-functions.html

 

[Bob Phillips]

I can get more than 5. What is your formula?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

This is my formula Bob:
=IF(ISNUMBER($BC12),IF(AND(ISBLANK(B28),ISTEXT(D28)),+D28,""),"")
In the END function I need 10 combiinations in order to evaluate it to TRUE.
What I did is to make and again the fith (see below), I don't know if it is
right, but I see the result is as what as I expected

=IF(ISNUMBER($BC12),IF(AND(ISBLANK(B28),ISTEXT(D28),ISBLANK(B29),ISTEXT(D29),AND(ISBLANK(B30),ISTEXT(D30))),+D30,""),"")

Appreciate your idea Bob,

Frank

 

[Bob Phillips]

Frank,

Can't get the problem as I see it, but maybe this will give you a steer

=IF(ISNUMBER($BC12),IF(AND(COUNTBLANK(B28:B30)=3,COUNTBLANK(D2830)=3),D30,""),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)