+ Reply to Thread
Results 1 to 2 of 2

Multiple Nested Ifs

  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2010
    Posts
    25

    Multiple Nested Ifs

    Hi Everyone,

    I've got multiple cells with strings of text that look like the following:

    07000178CA39DN8000000000 20150111 050099999999
    07000178CA39EN5600000000 20150111 020099999999
    07000357CA39DN8000000000 20151115 000099999999
    07000357CA39EN5600000000 20151115 000099999999


    The first 8 characters of the string correspond to an employee, and there are multiple lines for every single employee. Keeping that in mind, for every different employee in the list, I'm trying to validate that the following:
    1. Check the string that contains "DN80" as characters 13 to 16 for the value contained in characters 35 and 36
    2. If the value of characters 35 and 36 is higher than "04", and this is where it gets tricky, I need to go check in another line (that contains "EN56" as chr 13 to 16), but for the same employee (8 first characters), if the value of chr 35 and 36 is "02". If it's not, I need to turn it in red font.

    My main issue here is figuring out how to validate values in a different cell than the one with the first criteria, while remaining in the same employee (8 first digits).

    Do you think it can be done?

    Thanks a lot!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Multiple Nested Ifs

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Subs Nested
    By cp41 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2013, 03:52 PM
  2. IF ISERROR with multiple nested If's
    By dash11 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2013, 04:33 PM
  3. [SOLVED] Nested IF with multiple criteria
    By small_wonder in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-30-2012, 04:14 PM
  4. Nested if across multiple workbooks.
    By Chantel_S in forum Excel General
    Replies: 1
    Last Post: 02-25-2012, 09:17 AM
  5. Excel 2007 : multiple nested if
    By onestar in forum Excel General
    Replies: 8
    Last Post: 09-13-2011, 09:00 PM
  6. Multiple Nested IF(AND's in a formula
    By jwmartin32 in forum Excel General
    Replies: 2
    Last Post: 05-21-2008, 11:20 AM
  7. Nested If and Or fxn for multiple cells
    By Nightlily in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2007, 05:01 PM
  8. multiple If one nested then if overall result
    By swieduwi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2007, 05:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1