Results 1 to 4 of 4
  1. #1
    scatncs
    Guest

    Using Array Formula (97/SR 2)

    I'm trying to make a array formula that will return either a "YES" if the value in one cell is >= 6 AND the value of the other cell is >= .75, or a "NO" if one or both of the conditions are not true. Does anybody have any gudance as to how I can accomplish this?

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Array Formula (97/SR 2)

    So, we'll assume A1 is the one cell and A2 is the other cell.

    =if(and(a1>=6,a2>=.75),"Yes","No")

    But I don't see how that would be an array formula. (Perhaps you're using array in the wrong connotation?)

  3. #3
    scatncs
    Guest

    Re: Using Array Formula (97/SR 2)

    I got it. I have to also make the goals of 6 and .75 editable, so I set them up in there own cells and then created the following array:
    {=IF((J7>=$J$3)*(K7>=$K$3),"YES","NO")}

    It may not be the most elegant solution, but it worked.

    Thanks for the advice.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using Array Formula (97/SR 2)

    As written, that is not an array formula and does not need to be entered as one. Entering it as an array formula will only slow down recalculation.
    Legare Coleman

Posting Permissions

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