Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If Formula...help, please! (2000)

    I have been trying to come up with a formula for this for the past hour and forty-five minutes, and I just can't get it right. Any help would be greatly appreciated!

    Formula for cell D2 that answers: if E2, F2 or G2 equals "X", then D2 returns as "No", if false, then it returns as "yes".

    Thanks again.

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Formula...help, please! (2000)

    Does this do what you want?
    =IF(E2="X","No",IF(F2="X","NO", IF(G2="X","No","Yes")))
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Formula...help, please! (2000)

    The one "IF" solution would be:

    =IF(OR(E2="X",F2="X",G2="X"),"No","Yes")

  4. #4
    New Lounger
    Join Date
    Jun 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If Formula...help, please! (2000)

    Greg, you're my hero! Thanks much, that works exactly as I wished.

    Cari Anne

    P. S. Mbarron, thank you, too.

Posting Permissions

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