Multiple If Statement Help

**vargs** · 12-06-2010, 10:57 AM

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:

Please Login or Register  to view this content.

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

**NBVC** · 12-06-2010, 11:05 AM

A bit confusing, but do you mean?

Please Login or Register  to view this content.

**vargs** · 12-06-2010, 11:39 AM

Forgive me, let me explain the logic a bit more and the addition I want to the code

The main input is J2 with secondary inputs K2:N2 and the output is O2

Please Login or Register  to view this content.

The only thing wrong with the above code is that IF J2=Not found, it is not outputting not found

Below is what I wanted to replicate to work with IF J2=Transfer

Please Login or Register  to view this content.

What this code says is just if I2 is not equal to GC, then follow this if statement:
If J2=discard, then if both K2:N2 say Agree, output Discard. If one of K2 or N2 say disagree then output conflict

If I2=GC, then follow this if statement:
If J2=discard, then all four of K2:N2: say agree, output Discard. If one of K2 through N2 say disagree then output conflict.

I wanted to just add on this block of code to the main formula(so it works with IFJ2=Transfer)

Please Login or Register  to view this content.

**NBVC** · 12-06-2010, 12:00 PM

Try:

Please Login or Register  to view this content.

I fixed your first issue too.. I think the Data Validation list had an extra space after the "Not Found" entry.

**vargs** · 12-06-2010, 12:37 PM

That worked wonders.
Also, thank you for fixing the other "not found" problem, I could not figure it out.

Thanks for your patience with me.
Your help is greatly appreciated.

Sincerely,

-vargs