Results 1 to 5 of 5
  1. #1
    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

    Thanks in advance

    JoeG

  2. #2
    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)
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2003
    Posts
    172
    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

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    The function (AND, OR, SUMPRODUCT, etc.) is listed first, then the operators * connect the various conditions.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    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
  •