Subtracting in excel
to subtract 50 from {20,20 ,20} respectively we get {0,0,10}
CodePudding user response：
Because you need to fix the cell to copy. Refer the cell with 50 as e.g. $A$1 for the cell to be fixed.
Subtracting in excel
to subtract 50 from {20,20 ,20} respectively we get {0,0,10}
CodePudding user response：
Because you need to fix the cell to copy. Refer the cell with 50 as e.g. $A$1 for the cell to be fixed.