# Multiple If Statement Help

1. ## 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 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

2. ## Re: Multiple If Statement Help

A bit confusing, but do you mean?

``Please Login or Register  to view this content.``

3. ## Re: Multiple If Statement Help

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.``

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.``

4. ## Re: Multiple If Statement Help

Try:

``Please Login or Register  to view this content.``

5. ## Re: Multiple If Statement Help

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.

Sincerely,

-vargs

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