Excel: Addning one more condition to Formula


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?


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of May 29, 2015.


For more resources for Microsoft Excel