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
Bookmarks