Addning one more condition to Formula

[Edwardryez]

I compare and update Columns in a table based in this formula:
=IF(AND(I2<>"",J2<>""),IF(J2-I2<>0,J2-I2,"Same"),IF(J2<>"","New",IF(AND(I2="",J2=""),"None","Removed")))
How can i modify that if = Removed then all the Row Cells After instead of =None, =Removed?

 

[gaz_chops]

Not sure about the different elements of your formula? Break it down, what do you want returned for each IF statement?

IF(AND(I2<>"",J2<>"")
IF(J2-I2<>0,J2-I2
IF(J2<>""
IF(AND(I2="",J2=""

 

[Edwardryez]

Not sure about the different elements of your formula? Break it down, what do you want returned for each IF statement?

IF(AND(I2<>"",J2<>"")
IF(J2-I2<>0,J2-I2
IF(J2<>""
IF(AND(I2="",J2=""

Let say i have the results in V
I compare Column Values I,J and if they are =, V="Same", if I="" and J<>"", V="New", If I<>"" and J="", V="Removed", If I="" and J="", V="None""

Next Column W get the Result from Comparing J and K, after Value Removed on V, W becomes "None" since J="" and K"", how can i keep it "Removed"?

 

[gaz_chops]

Let say i have the results in V
I compare Column Values I,J and if they are =, V="Same", if I="" and J<>"", V="New", If I<>"" and J="", V="Removed", If I="" and J="", V="None""

Next Column W get the Result from Comparing J and K, after Value Removed on V, W becomes "None" since J="" and K"", how can i keep it "Removed"?

Tell me for each If what result you expect, copy and paste this and add to the end what you expect.

IF(AND(I2<>"",J2<>"")
IF(J2-I2<>0,J2-I2
IF(J2<>""
IF(AND(I2="",J2=""

 

[Edwardryez]

ADVERTISEMENT

IF(J2-I2<>0,J2-I2,"Same"),IF(J2<>"","New",IF(AND(I2="",J2=""),"None","Removed"

 

[gaz_chops]

Now you have gone from 4 IFs to 3?

=IF(and(J2-I2<>0,J2-I2),"Same",IF(J2<>"","New",IF(AND(I2="",J2=""),"None","Removed"

 

[Edwardryez]

ADVERTISEMENT

thats what i need the 4th.
Lets say if I2="Removed" J2="Removed"

 

[gaz_chops]

thats what i need the 4th.
Lets say if I2="Removed" J2="Removed"

Sorry I can't help if you can't answer the question, see if someone else can.

 

[Edwardryez]

https://www.dropbox.com/s/bo1yjzihz7st6a0/opp.xlsx?dl=0

See the file

 

[gaz_chops]

Not sure but try

=IF(AND(I2="",J2="",COUNTA($I2:I2)=0),"None",IF(OR(J2>I2,AND(I2="",J2<>"")),"New",IF(AND(COUNTA(I2:J2)<>0,I2=J2),"Same","Removed")))