判斷二項跳行三格 (9333)


C9:E10=IF(SUMPRODUCT(SIGN(N(OFFSET(C1,{3,5},))-N(OFFSET(C1,{1,3},))))=0,"最後"&IF(C2-C6>0,"减","增"),"递"&IF(C2-C6>0,"减","增"))


留言