Results 1 to 5 of 5

Multiple If Statement Help

Threaded View

vargs Multiple If Statement Help 12-06-2010, 10:57 AM
NBVC Re: Multiple If Statement Help 12-06-2010, 11:05 AM
vargs Re: Multiple If Statement Help 12-06-2010, 11:39 AM
NBVC Re: Multiple If Statement Help 12-06-2010, 12:00 PM
vargs Re: Multiple If Statement Help 12-06-2010, 12:37 PM
  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    59

    Multiple If Statement Help

    Hello,

    I was wondering if I could replicate the logic for one of this if statements to work with another entry word, "Transfer"

    In group 1 I have data validation Maintain, Return, Transfer, Discard, and Not Found
    In groups 2-5, I have data validation agree/disagree

    I have attached a working copy of this code

    Here is the working formula that I would like to add to:
    =IF(OR(J2={"Maintain","Not Found"}),J2,IF(J2="Return",IF(L2="Agree","Save","Conflict"),
    
    IF(J2="Discard",IF(I2<>"GC",IF(COUNTIF(K2:L2,"Agree")=2,"Discard","Conflict"),
    IF(COUNTIF(K2:N2,"Agree")=4,"Discard","Conflict")))))
    I would like to replicate the second block of code ..."IF(J2="Discard"...) to work for IF J2=Transfer. I would like the same logic to apply to if J2=transfer and the output of both statements if accepted to be Transfer.

    Thanks,

    -vargs
    Attached Files Attached Files
    Last edited by vargs; 12-06-2010 at 12:40 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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