Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    multiple if statements (xp & 2003)

    I submitted a posting last week and was returned a answer that worked well. A slight change to the scenerio had come about. In the attached spreadsheet you will see that column B was added. the formula should read that if : cell A2 = "no" and if cell B2="m" then the formula should be (col E - Col D) times the ratio formula. However if cell A2 = "no" and if cell B2="a" then the formula should be (col E) times the ratio formula cell.

    Also, is cells in column B did not have an "m" or "a" column H should state "M or A ?". Many Thanks

    is this possible?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple if statements (xp & 2003)

    Does this do what you want (enter in H2, fill down)?

    =IF(NOT(OR(B2="M",B2="A")),"M or A?",IF(A2&C2="","ERROR",IF(C2="","NO-DATE",IF(A2="","YES/NO",(ROUND((FYE_2008-C2)/366*IF(A2="NO",E2,G2),-1))))))

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple if statements (xp & 2003)

    Or this? (I'm getting very confused)

    =IF(NOT(OR(B2="M",B2="A")),"M or A?",IF(A2&C2="","ERROR",IF(C2="","NO-DATE",IF(A2="","YES/NO",(ROUND((FYE_2008-C2)/366*IF(A2="NO",IF(B2="M",E2-D2,E2),G2),-1))))))

  4. #4
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: multiple if statements (xp & 2003)

    I will give it a shot. Thanks

Posting Permissions

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