如果數字在A1,在B1輸入以下設定:=if(mod(left(right(A1,2),1),2)=0,"偶數","奇數")內容說明:取出倒數第二個數值:left(right(A1,2),1),2)如果除以2餘數為0定義為偶數,否則維基數:if(mod()=0,"偶數","奇數")