判斷數字型態 小數 整數 整百數 (13311)

C2=IF(MOD(B2,1),"小數",IF(MOD(B2,100),"整數","整百數"))

另解=CHOOSE(SUM(N(MOD(B2,{1,100})=0))+1,"小數","整數","整百數")

另解=LOOKUP(LEN(MOD(B2%,1)),{1,4,5},{"整百數","整數","小數"})