如何再差異位置 (11708)

D2=IF(B2<C2,"上升",IF(B2=C2,"持平","下降"))

另解=TEXT(((B2<C2)-(B2>C2))*(B2<>C2),"上升;下降;持平")



留言