Function AND
 

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

Function AND
 

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/ExcelArticle...functions.html

"Frank Situmorang" wrote:

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

Function AND
 

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)

"Frank Situmorang" wrote in message
...
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

Function AND
 

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" wrote:

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)

"Frank Situmorang" wrote in message
...
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

Function AND
 

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,C OUNTBLANK(D28:D30)=3),D30,""),"")

--
HTH

Bob

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

"Frank Situmorang" wrote in message
...
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" wrote:

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)

"Frank Situmorang" wrote in message
...
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