# Thread: I don't understand what Excel did

1. Registered User
Join Date
Dec 2003
Posts
172

## Unanswered: I don't understand what Excel did

=IF((C11<5)*AND(C11<>3),1,0)

why did Excel put an asterisk before the AND for my 2nd condition?

is this the new way to enter multiple IF conditions?
*AND(condition2)*AND(condition3) etc

is this converted to an array formula?

I can't find any help on the web or in any of my Excel books on *AND

JoeG

2. Registered User
Join Date
Oct 2003
Posts
1,091
=IF((C11<5)*AND(C11<>3),1,0)
It should be this:

=IF(AND(C11<5)*(C11<>3),1,0)

More conditions then

=IF(AND(C11<5)*(C11<>3)*(D11=25),1,0)

3. Registered User
Join Date
Dec 2003
Posts
172

need a bit more understanding on this...

Why is AND used for only the first set of parenthesis?
Why did Excel insert *AND rather than just * as you demonstrated?

thanks again

JoeG

4. Registered User
Join Date
Oct 2003
Posts
1,091
The function (AND, OR, SUMPRODUCT, etc.) is listed first, then the operators * connect the various conditions.

5. Registered User
Join Date
Dec 2003
Posts
172
The function (AND, OR, SUMPRODUCT, etc.) is listed first, then the operators * connect the various conditions.

okay got that but why does Excel do this:

*AND vs just *?

does it yield a different result?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•