字串中取數據 判斷大小 (14595)

E2=IF(C2/LOOKUP(99,B$2:B2)-1%%-MID(LOOKUP("嫻",A$2:A2),IF(ISERR(FIND("前",LOOKUP("嫻",A$2:A2))),9,4),3)<0,INDEX(TRIM(MID(SUBSTITUTE(LOOKUP("嫻",A$2:A2),":",REPT(" ",99)),{1,99},99)),ISERR(FIND("前",LOOKUP("嫻",A$2:A2)))+1),"")