HOME / ¹®¼°øÀ¯ / ºñÁî´Ï½º / ±âŸ/ÀϹÝ
0
0°ÇÀÇ Èı⺸±âÀÚÁÖ »ç¿ëÇÏ´Â ¿¢¼¿ ÇÔ¼ö ¸ñ·Ï ¸®½ºÆ®¿¡ ´ëÇØ ±â¼úÇÑ Âü°íÀÚ·áÀÔ´Ï´Ù.
Àüü 33 page Áß 14 page±îÁö ¹Ì¸®º¸±â°¡ °¡´ÉÇÕ´Ï´Ù.
Áß¿äµµ ÇÔ¼ö ¹üÁÖ ÇÔ¼ö À̸§ ÇÔ¼ö ±¸¹® ÇÔ¼ö ¼³¸í
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö abs abs(number) ¼ýÀÚÀÇ Àý´ë°ª ±¸Çϱâ
aµî±Þ ³í¸® ÇÔ¼ö and and(logical1,logical2,.) Àμö°¡ ¸ðµÎ trueÀÏ ¶§ true°¡ ¹Ýȯ
aµî±Þ Åë°è ÇÔ¼ö average average(number1,number2,.) ÀμöµéÀÇ Æò±Õ ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö averagea averagea(value1,value2,.) ¼ýÀÚ, ÅؽºÆ®, ³í¸®°ª µî ÀμöµéÀÇ Æò±Õ ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö count countif(range,criteria) Àμö ¸ñ·Ï¿¡¼ ¼ýÀÚÀÇ °³¼ö ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö counta counta(value1,value2,.) Àμö ¸ñ·Ï¿¡¼ °ªÀÇ °³¼ö ±¸Çϱâ
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö date date(year,month,day) ƯÁ¤ ³¯Â¥ÀÇ ÀÏ·Ã ¹øÈ£ ±¸Çϱâ
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö datevalue datevalue(date text) ÅؽºÆ® Çü½ÄÀÇ ³¯Â¥¸¦ ÀÏ·Ã ¹øÈ£·Î º¯È¯
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö day day(serial number) ÀÏ·Ã ¹øÈ£¸¦ ÇØ´ç ³¯Â¥¸¦ ³ªÅ¸³»´Â ÀÏ·Î º¯È¯
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö hour hour(serial number) ÀÏ·Ã ¹øÈ£¸¦ ½Ã°£À¸·Î º¯È¯
aµî±Þ ³í¸® ÇÔ¼ö if if(logical test,value if true,value if false) ¼öÇàÇÒ ³í¸® °Ë»ç¸¦ ÁöÁ¤
aµî±Þ Åë°è ÇÔ¼ö max max(number1,number2,.) Àμö ¸ñ·Ï¿¡¼ ÃÖ´ë°ª ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö maxa maxa(value1,value2,.) ¼ýÀÚ ÅؽºÆ® ³í¸®°ª µî Àμö ¸ñ·Ï¿¡¼ ÃÖ´ë°ª ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö min minute(serial number) Àμö ¸ñ·Ï¿¡¼ ÃÖ¼Ò°ª ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö mina mina(value1,value2,.) ¼ýÀÚ ÅؽºÆ® ³í¸®°ª µî Àμö ¸ñ·Ï¿¡¼ ÃÖ¼Ò°ª ±¸Çϱâ
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö minute minute(serial number) ÀÏ·Ã ¹øÈ£¸¦ ºÐÀ¸·Î º¯È¯
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö mod mod(number,divisor) ³ª´©±âÀÇ ³ª¸ÓÁö ±¸Çϱâ
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö month month(serial number) ÀÏ·Ã ¹øÈ£¸¦ ¿ù·Î º¯È¯
aµî±Þ ³í¸® ÇÔ¼ö not not(logical) ÀμöÀÇ ³í¸® ¿ª ±¸Çϱâ
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö now now() ÇöÀç ³¯Â¥¿Í ½Ã°£ÀÇ ÀÏ·Ã ¹øÈ£ ±¸Çϱâ
aµî±Þ ³í¸® ÇÔ¼ö or or(logical1,logical2,.) Àμö Áß ¾î´À Çϳª¶óµµ trueÀ̸é true°¡ ¹Ýȯ
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö pi pi() pi °ª ±¸Çϱâ
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö product product(number1,number2,.) ÀμöµéÀÇ °ö ±¸Çϱâ
aµî±Þ Åë°è ÇÔ¼ö rank rank(number,ref,order) ¼ö ¸ñ·Ï¿¡¼ ÁöÁ¤ÇÑ ¼öÀÇ Å©±â ¼øÀ§ ±¸Çϱâ
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö round round(number,num digits) ¼ýÀÚ¸¦ ÁöÁ¤ÇÑ ÀÚ¸´¼ö·Î ¹Ý¿Ã¸²
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö rounddown rounddown(number,num digits) 0¿¡ °¡±î¿î ¼ýÀÚ·Î ³»¸²µÈ ¼ýÀÚ ±¸Çϱâ
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö roundup roundup(number,num digits) 0¿¡¼ ¸ÕÂÊÀ¸·Î ¿Ã¸²µÈ ¼ýÀÚ ±¸Çϱâ
aµî±Þ ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö second second(serial number) ÀÏ·Ã ¹øÈ£¸¦ ÃÊ·Î º¯È¯
aµî±Þ ¼öÇÐ ¹× »ï°¢¹ý ÇÔ¼ö sum sum(number1,number2,.) ÀμöµéÀÇ ÇÕ ±¸Çϱâ (ÀÌÇÏ »ý·«)
¹ÞÀº º°Á¡
0/5
0°³ÀÇ º°Á¡
¹®¼°øÀ¯ ÀڷḦ µî·ÏÇØ ÁÖ¼¼¿ä.
¹®¼°øÀ¯ Æ÷ÀÎÆ®¿Í Çö±ÝÀ» µå¸³´Ï´Ù.
Æ÷ÀÎÆ® : ÀÚ·á 1°Ç´ç ÃÖ´ë 5,000P Áö±Þ
Çö±Ý : ÀÚ·á 1°Ç´ç ÃÖ´ë 2,000¿ø Áö±Þ