[算表] 請教如何設定函數或巨集
朋友來信請教以下問題,有勞賜教,謝謝!
I want to use Excel to calculate based on on/off of these values added up:2,
4, 8, 16, 32, 64, 128, 256 through 32768.
Each cell of the above values can be either on or off. You see there can be
many combinations. For example:
2 on
4 off
8 on
16 on
32 off
64 on
128 off
Total = 90
I just need a basic guideline (e.g. Excel functions) to get started and I can
build all the combinations myself into the Excel.
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.110.192.63
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1425997469.A.A56.html
→
03/10 22:36, , 1F
03/10 22:36, 1F
→
03/10 22:36, , 2F
03/10 22:36, 2F
→
03/11 10:08, , 3F
03/11 10:08, 3F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
