朋友來信請教以下問題,有勞賜教,謝謝!
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.