Excelを楽しもう! 〜〜〜 関数で遊ぼう 〜〜〜 |
. | A | B | C | D | E | F | G | H |
1 | . | A | . | B | . | C | . | 合計枚数 |
2 | . | 58、763 | . | 24、887 | . | 87、186 | . | . |
3 | . | 枚数 | 余り | 枚数 | 余り | 枚数 | 余り | . |
4 | 10000 | =int(B2/$A$4) | =mod(B2/$A$4) | =int(d2/$A$4) | =mod(d2/$A$4) | =int(f2/$A$4) | =modf2/$A$4) | =B4+D4+F4 |
5 | 5000 | =int(c4/$A$5) | =mod(c4/$A$5) | =int(e4/$A$5) | =mod(e4/$A$5) | =int(g4/$A$5) | =mod(g4/$A$5) | =B5+D5+F5 |
6 | 1000 | =int(c5/$A$6) | =mod(c5/$A$6) | =int(e5/$A$6) | =mod(e5/$A$6) | =int(g5/$A$6) | =mod(g5/$A$6) | =B6+D6+F6 |
7 | 500 | =int(c6/$A$7) | =mod(c6/$A$7) | =int(e6/$A$7) | =mod(e6/$A$7) | =int(g6/$A$7) | =mod(g6/$A$7) | =B7+D7+F7 |
8 | 100 | =int(c7/$A$8) | =mod(c7/$A$8) | =int(e7/$A$8) | =mod(e7/$A$8) | =int(g7/$A$8) | =mod(g7/$A$8) | =B8+D8+F8 |
9 | 50 | =int(c8/$A$9) | =mod(c8/$A$9) | =int(e8/$A$9) | =mod(e8/$A$9) | =int(g8/$A$9) | =mod(g8/$A$9) | =B9+D9+F9 |
10 | 10 | =int(c9/$A$10) | =mod(c9/$A$10) | =int(e9/$A$10) | =mod(e9/$A$10) | =int(g9/$A$10) | =mod(g9/$A$10) | =B10+D10+F10 |
11 | 5 | =int(c10/$A$11) | =mod(c10/$A$11) | =int(e10/$A$11) | =mod(e10/$A$11) | =int(g10/$A$11) | =mod(g10/$A$11) | =B11+D11+F11 |
12 | 1 | =int(c12/$A$13) | . | =int(e12/$A$13) | . | =int(g12/$A$13) | . | =B13+D13+F13 |
13 | . | . | . | . | . | . | . | . |
. | A | B | C | D | E | F | G | H |
1 | . | A | . | B | . | C | . | 合計枚数 |
2 | . | 58、763 | . | 24、887 | . | 87、186 | . | . |
3 | . | 枚数 | 余り | 枚数 | 余り | 枚数 | 余り | . |
4 | 10000 | 5 | 8763 | 2 | 4887 | 8 | 7186 | 15 |
5 | 5000 | 1 | 3763 | 0 | 4887 | 1 | 2186 | 2 |
6 | 1000 | 3 | 763 | 4 | 887 | 2 | 186 | 9 |
7 | 500 | 1 | 263 | 1 | 387 | 0 | 186 | 2 |
8 | 100 | 2 | 63 | 3 | 87 | 1 | 86 | 6 |
9 | 50 | 1 | 13 | 1 | 37 | 1 | 36 | 3 |
10 | 10 | 1 | 3 | 3 | 7 | 3 | 6 | 7 |
11 | 5 | 0 | 3 | 1 | 2 | 1 | 1 | 2 |
12 | 1 | 3 | . | 2 | . | 1 | . | 9 |
13 | . | . | . | . | . | . | . | . |
. | Ctrl+F4 | ブックを閉じる | . |
. | Alt+F2 | 作業中のブックを保存 | . |
. | Alt+F4 | Excelの終了 | . |
. | Shift+F4 | ワークシートを閉じる | . |
. | Shift+F11 | ワークシートの挿入 | . |
SEO | [PR] 爆速!無料ブログ 無料ホームページ開設 無料ライブ放送 | ||