HOME>¿ÀÇǽº / ÀÚ°ÝÁõ>¿¢¼¿ÇÔ¼ö | ¿¢¼¿VBA>¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2003
¾ËÁö¿À ÆÐŰÁö

¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2003

17ȸÂ÷ ¼Ó¼º°úÁ¤
Àüü : 4½Ã°£ 11ºÐ|ȸÂ÷´ç Æò±Õ : 14ºÐ45ÃÊ

ÀÌ¿ë±â°£ 2°³¿ù

Àü¹®°­»ç : ¾ËÁö¿À R&D [¿ÀÇǽº]

140,000¿ø85,000¿ø
¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® 2003 Àΰ­ Æò»ý±³À°¿ø ±³À° ¾È³»
¿¢¼¿ ÇÔ¼ö ¸ðÀ½ À¸·Î ¸ðµç ÇÔ¼ö¸¦ ¸ð¾Æ³õÀº °­ÀÇ´Â ¾ËÁö¿À R&D [¿ÀÇǽº]ÆÀ¿¡¼­ Á÷Á¢ °³¹ßµÈ ¿¢¼¿ ÇÔ¼ö ÃÑÁ¤¸® ÇÑ Àü¹®°­ÀÇ·Î ¿¢¼¿¿¡¼­ »ç¿ëµÇ´Â ¸ðµç ÇÔ¼öµé¿¡ ´ëÇØ¼­ ÃÑÁ¤¸® ¸¦ ÇÑ °­ÁÂÀÔ´Ï´Ù. ÇØ´ç °­ÀǸ¦ ¼ö°­ÇÏ½Ã¸é ¿¢¼¿ ÇÔ¼ö ¸ðÀ½ ÀÇ ½Ç½À¿¹Á¦¸¦ ÅëÇØ ¿¢¼¿ ÇÔ¼ö¸¦ ½Ç¹«¿¡¼­ Ȱ¿ëÇÒ ¼ö ÀÖ´Â ¼öÁرîÁö ¸¶½ºÅÍÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
  • ¼öÇÐ/»ï°¢
  • 01.16ºÐ power, exp, sum, sumif, product, sumproduct ÇÔ¼ö

  • 02.11ºÐ sumsq, quotient, mod, subtotal, rand, randbetween ÇÔ¼ö

  • 03.12ºÐ trunc, rounddown, int, floor, ceiling ÇÔ¼ö

  • 04.20ºÐ roundup, mround, even, odd, sqrt, fact, combin, gcd, lcm ÇÔ¼ö

  • Åë°è
  • 05.12ºÐ count, counta, countif, counfblank , rank, percentrank ÇÔ¼ö

  • 06.13ºÐ quartile, percentile, large, small, median ÇÔ¼ö

  • 07.14ºÐ max, maxa, min, mina, mode, average, averagea, trimmean, geomean ÇÔ¼ö

  • ³¯Â¥/½Ã°£
  • 08.12ºÐ year, month, day, edate, eomonth, workday ÇÔ¼ö

  • 09.19ºÐ date, time, datedif, days, networkdays, yearfrac, neeknum, today, now ÇÔ¼ö

  • ³í¸®/ã±â/ÂüÁ¶¿µ¿ª
  • 10.11ºÐ if, and, or, index ÇÔ¼ö

  • 11.14ºÐ vlookup, hlookup, choose, match, transposeÇÔ¼ö

  • µ¥ÀÌÅͺ£À̽º
  • 12.15ºÐ dget, dcount, dcounta, dproduct, daverage, dsum, dmax, dmin ÇÔ¼ö

  • 13.13ºÐ istext, isnotext, isnumber, iserror, iseven, isodd, type ÇÔ¼ö

  • À繫
  • 14.21ºÐ sln, db, fv, fvschedule, pmt, ppmt, ipmt ÇÔ¼ö

  • 15.19ºÐ ispmt, cumipmt, cumprinc, nper, pv, npv, xnpv ÇÔ¼ö

  • ÅØ½ºÆ®
  • 16.13ºÐ find, search, left, mid, right ÇÔ¼ö

  • 17.16ºÐ exact, concatenate, fixed, text, dollar, junja, asc, replace, replaceb, substitute, rept ÇÔ¼ö



¾ËÁö¿À ÆÐŰÁö