判斷多個指定起止數間數字 (13940)

B2=IF(MOD(INT((A2-1)/10),2),"背面","正面")

I2=IF(SUMPRODUCT((E$2:E$8<=H2)*(F$2:F$8>=H2)),"正面","背面")



留言