[算表] 累進加總的對應
軟體: Microsoft Office
版本: 2007
A B C
1 XYZ 5 9
2 ABC 3
3 LMN 4
4 DEF 2
我想要做到，
如果C1<5 ，結果為 XYZ
如果C1<5+3 ，結果為 ABC
如果C1<5+3+4 ，結果為 LMN
如果C1<5+3+4+2，結果為 DEF
嘗試這樣寫，可是失敗了
=lookup(C1,{B1, B1+B2, B1+B2+B3, B1+B2+B3+B4},{A1:A4})
感謝大大！
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.227.239.223
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1399746980.A.7F2.html
→
05/11 11:01, , 1F
05/11 11:01, 1F
→
05/11 11:02, , 2F
05/11 11:02, 2F
→
05/11 18:16, , 3F
05/11 18:16, 3F
→
05/11 18:24, , 4F
05/11 18:24, 4F
推
05/12 09:04, , 5F
05/12 09:04, 5F
→
05/12 11:39, , 6F
05/12 11:39, 6F
→
05/12 18:18, , 7F
05/12 18:18, 7F
→
05/12 18:18, , 8F
05/12 18:18, 8F
→
05/12 18:19, , 9F
05/12 18:19, 9F