Edwardryez
New Member
- Joined
- Apr 28, 2014
- Messages
- 48
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?
=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?