Current location - Training Enrollment Network - Mathematics courses - In excel, the total score is equal to the sum of 40% in Chinese and 60% in mathematics. Which function should I use? How to operate?
In excel, the total score is equal to the sum of 40% in Chinese and 60% in mathematics. Which function should I use? How to operate?
If the Chinese score is in column A, the math score is in column B, and the total score is in column C, enter "=A 1*40%+B 1*60%" in the cell in column C, click C 1, move the mouse to the lower right corner of the cell, and a cross icon will appear, and then drop down.