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 J=Removed then  K=Removed instead of None?

=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:U2)<>0,I2=J2),"Same","Removed"))))

Thanks to gaz_chops

• Marked as answer by Eugene Laho 14 hours 23 minutes ago
• Edited by Eugene Laho 10 hours 36 minutes ago

=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:U2)<>0,I2=J2),"Same","Removed"))))

Thanks to gaz_chops

• Marked as answer by Eugene Laho Friday, May 29, 2015 5:05 PM
• Edited by Eugene Laho Friday, May 29, 2015 8:52 PM

=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:U2)<>0,I2=J2),"Same","Removed"))))

Thanks to gaz_chops

• Marked as answer by Eugene Laho Friday, May 29, 2015 5:05 PM
• Edited by Eugene Laho Friday, May 29, 2015 8:52 PM

Hi,

Thanks for visiting our forum and sharing your experience here. It'll be benefited to our communicator.

Have a good time.

Regards,

George Zhao
TechNet Community Support