Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nested If Thens (1)

    Thank you to whomever helps me! I need a formula that can go from cell to cell when certain criteria isn't met and then finally put in data in another cell. For instance, I would like the data to end up in E1, I need the formula to look at A1 and if it meets my criteria then it puts the data in E1, if not then it moves on to B1, same thing, then C1, same thing SO if A1, B1, and C1 do not match up then it puts in D1's data into E1, but if one of the cells does meet the criteria then it stops and puts that data into E1 at any given cell, A1, B1, or C1. I hope this makes some sort of sense.

    Thank you!

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nested If Thens (1)

    Assuming the criteria is the same for each test...

    =IF(A1=Criteria,A1,IF(B1=Criteria,B1,IF(C1=Criteri a,C1,IF(D1=Criteria,D1,"Error"))))

    where "Criteria" is a named range

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Nested If Thens (1)

    Could you be specific, this sounds like it could be done with nested IFs, but it might be better using a VLOOKUP or MATCH function depending on what you want to do.

    If A1-D1 are values in ascending order for example and you want to fine the largest one greater than some value you could use a lookup function. If you are trying to do something else, multiple IFs might be appropriate.

    Steve

  4. #4
    New Lounger
    Join Date
    Sep 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nested If Thens (1)

    Thank you - it worked perfectly.

Posting Permissions

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