返回列表 上一主題 發帖

如何以重量尋找所屬答案

回復 1# Qin

試試看
=LOOKUP(G5,{0,0.1,38,76,113,151,188,226,264},{"","100000000008081","100000000008091","100000000008101","100000000008111","100000000008121","100000000008131","100000000008141","100000000008151"})

TOP

回復 5# Qin

你要在F5那格貼上公式才行哦~

你問的4的意思,就是函數=LEFT(TEXT,顯示幾個字)

TOP

        靜思自在 : 得理要饒人,理直要氣和。
返回列表 上一主題