카테고리 없음

엑셀 함수 알려줘

우유빛 2023. 5. 9. 17:44

서 작성하고 있는데 아직 한개도 안됐어서 그냥 빠르게 이름만 포스팅하는게 더 낫겠다 하하

엑셀 함수들

  1. AVERAGE(number1,number2,...)

  2. COUNT(value1,value2,...)

  3. COUNTBLANK(range)

  4. COUNTA(value1,value2,...)

  5. COUNTIF(range,criteria)

  6. COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2,...)

  7. DATE(year,month,day)

  8. DATEVALUE(date_text)

  9. DAY(serial_number)

  10. DAYS(end_date,start_date)

  11. DAYS360(start_date,end_date,method)

  12. EDATE(start_date,months)

  13. EOMONTH(start_date,months)

  14. HOUR(serial_number)

  15. IF(logical_test,value_if_true,value_if_false)

  16. IFERROR(value,value_if_error)

  17. IFNA(value,value_if_na)

  18. IFS(logical_test,value_if_true,logical_test,value_if_true,...)

  19. INDEX(array,row_num,column_num)

  20. ISBLANK(value)

  21. ISERROR(value)

  22. ISEVEN(value)

  23. ISLOGICAL(value)

  24. ISNA(value)

  25. ISNONTEXT(value)

  26. ISNUMBER(value)

  27. ISODD(value)

  28. ISREF(value)

  29. ISTEXT(value)

  30. MINUTE(serial_number)

  31. MONTH(serial_number)

  32. NOW()

  33. SECOND(serial_number)

  34. SUM(number1,number2,...)

  35. SUMIF(range,criteria,sum_range)

  36. SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,...)

  37. TIME(hour,minute,second)

  38. TIMEVALUE(time_text)

  39. TODAY()

  40. VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

  41. WEEKDAY(serial_number,return_type)

  42. WEEKNUM(serial_number,return_type)

  43. WORKDAY(start_date,days,holidays)

  44. WORKDAY.INTL(start_date,days,weekend,holidays)

  45. YEAR(serial_number)

  46. YEARFRAC(start_date,end_date,basis)

  47. AND(logical1,logical2,...)

  48. FALSE()

  49. IF(logical_test,value_if_true,value_if_false)

  50. NOT(logical)

  51. OR(logical1,logical2,...)

  52. TRUE()

  53. XOR(logical1,logical2,...)

  54. CHAR(number)

  55. CODE(text)

  56. CONCATENATE(text1,text2,...)

  57. DOLLAR(number,decimals)

  58. EXACT(text1,text2)

  59. FIND(find_text,within_text,start_num)

  60. LEFT(text,num_chars)

  61. LEN(text)

  62. LOWER(text)

  63. MID(text,start_num,num_chars)

  64. PROPER(text)

  65. REPLACE(old_text,start_