Excel(エクセル)基本講座:CHOOSE関数の使い方 |
||
| B | C | |
| 2 | 2 | 2です |
| 3 | 0 | #VALUE! |
| 4 | 5 | #VALUE! |
| 5 | 3.4 | 3です |
| B | C | |
| 2 | 2009/7/1 | 水 |
| 3 | 2009/7/2 | 木 |
| 4 | 2009/7/3 | 金 |
| 5 | 2009/7/4 | 土 |
| 6 | 2009/7/5 | 日 |
| 7 | 2009/7/6 | 月 |
| 8 | 2009/7/7 | 火 |
| 9 | 2009/7/8 | 水 |
| B | C | |
| 2 | 2009/7/1 | =CHOOSE(WEEKDAY(B2),"日","月","火","水","木","金","土") |
| 3 | 2009/7/2 | =CHOOSE(WEEKDAY(B3),"日","月","火","水","木","金","土") |
| 4 | 2009/7/3 | =CHOOSE(WEEKDAY(B4),"日","月","火","水","木","金","土") |
| 5 | 2009/7/4 | =CHOOSE(WEEKDAY(B5),"日","月","火","水","木","金","土") |
| 6 | 2009/7/5 | =CHOOSE(WEEKDAY(B6),"日","月","火","水","木","金","土") |
| 7 | 2009/7/6 | =CHOOSE(WEEKDAY(B7),"日","月","火","水","木","金","土") |
| 8 | 2009/7/7 | =CHOOSE(WEEKDAY(B8),"日","月","火","水","木","金","土") |
| 9 | 2009/7/8 | =CHOOSE(WEEKDAY(B9),"日","月","火","水","木","金","土") |
| B | C | D | E | F | G | |
| 2 | 商品A | 商品B | 商品C | 商品A | 50,000 | |
| 3 | 10,000 | 5,000 | 1,000 | 商品B | 25,000 | |
| 4 | 10,000 | 5,000 | 1,000 | 商品C | 5,000 | |
| 5 | 10,000 | 5,000 | 1,000 | |||
| 6 | 10,000 | 5,000 | 1,000 | |||
| 7 | 10,000 | 5,000 | 1,000 |
| B | C | D | E | F | G | |
| 2 | 商品A | 商品B | 商品C | 商品A | 50,000 | |
| 3 | 10,000 | 5,000 | 1,000 | 商品B | 25,000 | |
| 4 | 10,000 | 5,000 | 1,000 | 商品C | 5,000 | |
| 5 | 10,000 | 5,000 | 1,000 | |||
| 6 | 10,000 | 5,000 | 1,000 | |||
| 7 | 10,000 | 5,000 | 1,000 |
PageViewCounter
Since2006/2/27