=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

Thanks in advance

JoeG

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)

Shades,

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

The function (AND, OR, SUMPRODUCT, etc.) is listed first, then the operators * connect the various conditions.

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?