在两Excel表格中求学生上升或下降了 多少分,需要函数计算(如图)_百度知...答:假设你上面一张表格是Sheet2,下面一张是Sheet1,Sheet2中的E2 =IF(VLOOKUP(C2,Sheet1!$C$2:$D$17,2,0)-D2<0,ABS(VLOOKUP(C2,Sheet1!$C$2:$D$17,2,0)-D2)&"↑",IF(VLOOKUP(C2,Sheet1!$C$2:$D$17,2,0)-D2=0,"←→",ABS(VLOOKUP(C2,Sheet1!$C$2:$D$17,2,0)-D...