評語 三次成績 (11763)

E2=IF(B2=C2,IF(C2<D2,"先平後升",IF(C2>D2,"先平後降","持平")),CHOOSE(SUMPRODUCT(SIGN(C2:D2-B2:C2))+SIGN(C2-B2)+4,"降","先降後平","先降後升","","先升後降","先升後平","升"))



留言