|
|
|
|
|
1 |
[ÇÔ¼ö] º¹¸®°è»ê ¿ø±Ý¹Ì·¡°¡Ä¡(FVSCHEDULE) |
: |
|
|
2 |
[ÇÔ¼ö] ¸Å¿ù»óȯÇÒ ¿ø±Ý±¸Çϱâ(PPMT) |
: |
|
|
3 |
[ÇÔ¼ö] ¸Å¿ù »óȯÇÒ ÀÌÀÚ±¸Çϱâ(IPMT) |
: |
|
|
4 |
[ÇÔ¼ö] ¸Å¿ù »óȯÇÒ ÃѾױ¸Çϱâ(PMT) |
: |
|
|
5 |
[ÇÔ¼ö] ¸Å´Þ °°Àº±Ý¾×ÀÇ ÀÌÀÚ±¸Çϱâ(ISPMT) |
: |
|
|
6 |
[ÇÔ¼ö] ´ëÃâ±Ý ÀÌÀÚÀÇ ´©°è¾×±¸Çϱâ(CUMIPMT) |
: |
|
|
7 |
[ÇÔ¼ö] ´ëÃâ±Ý ÃѾױ¸Çϱâ(CUMPRINC) |
: |
|
|
8 |
[ÇÔ¼ö] ÁöºÒ Ƚ¼ö ±¸Çϱâ(NPER) |
: |
|
|
9 |
[ÇÔ¼ö] ´ëÃâ±Ý(ÇöÀç°¡Ä¡) ±¸Çϱâ(PV) |
: |
|
|
10 |
[ÇÔ¼ö] ÅõÀÚ¿¡ ´ëÇÑ ÇöÀç°¡Ä¡ ±¸Çϱâ(NPV) |
: |
|
|
11 |
[ÇÔ¼ö] Çö±Ý È帧¿¡ ´ëÇÑ ÇöÀç°¡Ä¡±¸Çϱâ(XNPV) |
: |
|
|
12 |
[ÇÔ¼ö] ¹®ÀÚ¿ À§Ä¡°Ë»ö(FIND) |
: |
|
|
13 |
[ÇÔ¼ö] ¹®ÀÚ¿ ºñ±³Çϱâ(EXACT) |
: |
|
|
14 |
[ÇÔ¼ö] ¼ö¸¦ ¹Ý¿Ã¸²ÇÏ¿© ¹®ÀÚ¿¸¸µé±â(FIXED) |
: |
|
|
15 |
[ÇÔ¼ö] ¹®ÀÚ¿·Î º¯È¯È÷±â(TEXT) |
: |
|
|
16 |
[ÇÔ¼ö] ¼öÄ¡¸¦ ´Þ·¯Çü½ÄÀ¸·Î º¯È¯Çϱâ(DOLLAR) |
: |
|
|
17 |
[ÇÔ¼ö] ¹®ÀÚ¿ ¹Ù²Ù±â(REPLACE) |
: |
|
|
18 |
[ÇÔ¼ö] ¹Ý°¢¹®ÀÚ ¸¸µé±â(ASC) |
: |
|
|
19 |
[ÇÔ¼ö] ³¯Â¥ÀÇ ÀϷùøÈ£ ±¸Çϱâ(DATE) |
: |
|
|
20 |
[ÇÔ¼ö] ȸ°è»ó ±Ù¹«Àϼö °è»êÇϱâ(DAYS360) |
: |
|
|
21 |
[ÇÔ¼ö] ÀÛ¾÷ÇÑ ³¯Â¥¸¸ °è»êÇϱâ(INTWORKDAYS) |
: |
|
|
22 |
[ÇÔ¼ö] ÁöÁ¤ÀÏÀÌ ¼ÓÇÑ ÁÖ °è»êÇϱâ(WEEKNUM) |
: |
|
|
23 |
[ÇÔ¼ö] ÃÖ´ë °ø¾à¼ö °è»êÇϱâ(GCD) |
: |
|
|
24 |
[ÇÔ¼ö] ÃÖ¼Ò °ø¹è¼ö °è»êÇϱâ(LCM) |
: |
|
|
25 |
[ÇÔ¼ö] °è½Â°ª °è»êÇϱâ(FACT) |
: |
|
|
26 |
[ÇÔ¼ö] Çà·É½Ä °è»êÇϱâ(MDETERM) |
: |
|
|
27 |
[ÇÔ¼ö] Çà·ÉÀÇ °ö °è»êÇϱâ(MMULT) |
: |
|
|
28 |
[ÇÔ¼ö] °ÅµìÁ¦°ö °è»êÇϱâ(POWER) |
: |
|
|
29 |
[ÇÔ¼ö] ³ª´°¼À ¸ò±¸Çϱâ(QUOTIENT) |
: |
|
|
30 |
[ÇÔ¼ö] ³¼ö ¿¹»óÇϱâ(RANDBETWEEN) |
: |
|
|
31 |
[ÇÔ¼ö] ÀÚ¸® ¿Ã¸²°ú ³»¸²(ROUNDUP,ROUNDDOWN) |
: |
|
|
32 |
[ÇÔ¼ö] °öÇÑ °ªÀÇ Çհ豸Çϱâ(SUMPRODUCT) |
: |
|
|
33 |
[ÇÔ¼ö] ºóµµ °è»êÇϱâ(FREQUENCY) |
: |
|
|
34 |
[ÇÔ¼ö] Á¶È Æò±Õ °è»êÇϱâ(HARMEAN) |
: |
|
|
35 |
[ÇÔ¼ö] ÃÖºó¼ö ã¾Æ³»±â(MODE) |
: |
|
|
36 |
[ÇÔ¼ö] Çà,¿ ¹øÈ£ ¼¿ Áּҷκ¯È¯(ADDRESS) |
: |
|
|
37 |
[ÇÔ¼ö] ¼¿ÀÇ ¿,Çà¹øÈ£ ¾Ë¾Æ³»±â(COLUMN,ROW) |
: |
|
|
38 |
[ÇÔ¼ö] ã±â/Â÷Á¶ ¹è¿Çü°ú º¤ÅÍÇü(LOOKUP) |
: |
|
|
39 |
[ÇÔ¼ö] ÁöÁ¤¼¿¿¡¼ Çà/¿À̵¿Çϱâ(OFFSET) |
: |
|
|
40 |
[ÇÔ¼ö] µ¥ÀÌÅͺ£À̽º ÀÌ¿ë°ö°è»êÇϱâ(DPRODUCT) |
: |
|
|
41 |
[ÇÔ¼ö] ´ë¼Ò¹®ÀÚ ¾Ë¸Â°Ô º¯È¯Çϱâ(PROPER) |
: |
|
|
42 |
[ÇÔ¼ö] ƯÁ¤ ¹®ÀÚÀÇ À§Ä¡Ã£±â(SEARCH) |
: |
|
|
43 |
[ÇÔ¼ö] ¹®ÀÚ º¯È¯Çϱâ(SUBSTITUTE) |
: |
|
|
44 |
[ÇÔ¼ö] ¹®ÀÚ¿ÀÇ ¾çÂÊ °ø¹éÁ¦°Å(TRIM) |
: |
|
|
45 |
[ÇÔ¼ö] ÇÔ¼ö¸¦ »ç¿ëÇØ Åëȱâȣǥ½Ã(WON) |
: |
|
|
46 |
[ÇÔ¼ö] ³¯Â¥¸¦ ÂüÁ¶ÇÏ¿© ´Ù¸¥ ¹®ÀÚ¿°ú ¿¬°áÇϱâ |
: |
|
|
47 |
[ÇÔ¼ö] ÇÔ¼ö »çÀÌ¿¡ ¹®ÀÚ »ðÀÔÇϱâ |
: |
|
|
48 |
[ÇÔ¼ö] VLOOKUP, HLOOKUPÇÔ¼ö »ç¿ëÇϱâ |
: |
|
|
49 |
[ÇÔ¼ö] ³¯Â¥ ÂüÁ¶·Î ÄÚµå ÀÚµ¿»ý¼ºÇϱâ |
: |
|
|
50 |
[ÇÔ¼ö] µÑ ÀÌ»óÀÇ Á¶°ÇÀ¸·Î Çհ豸Çϱâ |
: |
|
|
51 |
[ÇÔ¼ö] Á¶°Çº° Æò±Õ±¸Çϱâ |
: |
|
|
52 |
[ÇÔ¼ö] ¼ºº°, ³ªÀÌ, ÅÂ¾î³ ¿äÀÏ ±¸Çϱâ |
: |
|
|
53 |
[ÇÔ¼ö] µî±Þ¿¡ ¸Â°Ô °¡ÁßÄ¡ ±¸Çϱâ |
: |
|
|
54 |
[ÇÔ¼ö] Áߺ¹ °Ë»ç |
: |
|
|
55 |
[ÇÔ¼ö] ½ÃÆ® ÅëÇÕ °è»ê |
: |
|
|
56 |
[ÇÔ¼ö] ¹é¸¸ÀÚ¸® ¹Ý¿Ã¸² |
: |
|
|
57 |
[ÇÔ¼ö] ¹Ý¿Ã¸²,¿Ã¸²,³»¸²ÇÔ¼ö |
: |
|
|
58 |
[ÇÔ¼ö] ±âÁØ¿¡ µû¶ó ¹Ý¿Ã¸²Çϱâ |
: |
|
|
59 |
[ÇÔ¼ö] ¼Ò¼öÀÚ¸® ¹ö¸² |
: |
|
|
60 |
[ÇÔ¼ö] ÀÚÁÖº¯°æµÇ´Â ¹®ÀÚÆ÷ÇÔ ¿¬»êÇϱâ |
: |
|
|
|