區間計算 註記 多 少 或相等 (14582)

K2=IF(F2="缺口",TEXT(SUM(OFFSET(G3,,,-LOOKUP(1,-MATCH("缺口",F3:F15,{1,0}))-(COUNTIF(F3:F15,"缺口")>0)))-G2,"多0;少0;相等"),"")