回復10# gong =LOOKUP(C2,{0,1,3,5,10},{0,7,10,14,15})+(C2>10)*INT(C2-10) 請問版主+(C2>10)*INT(C2-10)這種用法的規則跟IF有依樣嗎
確定! 回上一頁