Results 1 to 9 of 9

Nested If / Question about a logic

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2009
    Location
    Berlin
    MS-Off Ver
    Excel 2003
    Posts
    41

    Nested If / Question about a logic

    Good Day Experts,

    I would like to write a if condition which check parameters before filling one cell. If one condition is wrong the check should stop.
    In one data record the check will do the following:
    1. Check if B3=5 then continue and check if C3= true then continue and check if D3>=31.10.2011 write "pass" in cell G3.
    2. Check if B4=5 then continue and check if C4= true then continue and check if D4>=31.10.2011 if not, check if E4>D4 and check if F4>=D4 write "pass" in cell G4. otherwise "fail" and copy the F4 value into D4.
    3. Check if B5=1 write "fail" in cell G5.
    4. Check if B6=5 then continue and check if C6= true then continue, if not, write "fail" in cell G6.

    The sample is attached.

    Could you please help me on that way?

    Thank you in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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