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?

 

[Edwardryez]

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")))

Works Great except that when the Number is Changed there should Be the Difference as well, not Showing "New", Highlighted in Red Should be 6.
See the Second File.
https://www.dropbox.com/s/0ukuucd7vw1uazc/opp1.xlsx?dl=0

 

[gaz_chops]

I spotted that just after I posted earlier, try

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

 

[Edwardryez]

I spotted that just after I posted earlier, try

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

Solved.
Great Work, Thank You.

 

[gaz_chops]

You're welcome easier with the sample data.