Cookie ã®äœ¿çšã«ã€ããŠ.æ¬ãµã€ãã§ã¯ãåºæ¬æ©èœã®æäŸã«å¿ èŠãªå¿ é Cookie ã䜿çšããŠããŸããããã«ãåæããã ããå Žåã«éããã¢ã¯ã»ã¹è§£æ Cookie ãå©çšããŠå©çšç¶æ³ãææ¡ãããµãŒãã¹æ¹åã«åœ¹ç«ãŠãŸãã詳ãã㯠.
ãã®ããŒã«ã¯äœ¿ããããã£ãã§ããïŒ
ãã£ãŒãããã¯ã¯æ¹åã«åœ¹ç«ã¡ãŸã
æäŸExcelåžžçšåœæ°åç±»éæ¥ïŒå±ç€ºè¯æ³ãåæ°äžå®æç€ºäŸã
åé²ããExcel颿°ã®æ§æã»çšéã®åèã§ãæ°åŒã¯å®è¡ããŸãããäŸã®æååã¯åæãä¿ã¡ãŸããæ¥ä»è§£éã»è¡šç€ºã»å¯Ÿå¿é¢æ°ã¯çãšå°åèšå®ã«ãããŸããNPVã®åææè³ã颿°å€ã«ä¿®æ£ããFINDã®äœçœ®ãèšæ£ããŸããã䜿çšããçã®å ¬åŒææžã§ç¢ºèªããŠãã ããã åºå ž
åé²ããExcel颿°ã®æ§æã»çšéã®åèã§ãæ°åŒã¯å®è¡ããŸãããäŸã®æååã¯åæãä¿ã¡ãŸããæ¥ä»è§£éã»è¡šç€ºã»å¯Ÿå¿é¢æ°ã¯çãšå°åèšå®ã«ãããŸããNPVã®åææè³ã颿°å€ã«ä¿®æ£ããFINDã®äœçœ®ãèšæ£ããŸããã䜿çšããçã®å ¬åŒææžã§ç¢ºèªããŠãã ããã åºå ž
ããã¹ãã®æåæ°ãæ°ããŸãã
LEN(text)=LEN("Excel")DBCSã®èšèªèšå®ã«å¿ãããã€ãæ°ãæ°ããŸããUTF-8ã®ãã€ãé·ãèšç®ãã颿°ã§ã¯ãããŸããã
LENB(text)=LENB("äœ å¥œ")ããã¹ãã®å é ããæå®ããæåæ°ãåãåºããŸãã
LEFT(text, [num_chars])=LEFT("Toolkk",4)ããã¹ãã®æ«å°Ÿããæå®ããæåæ°ãåãåºããŸãã
RIGHT(text, [num_chars])=RIGHT("Toolkk",2)éå§äœçœ®ãšæåæ°ãæå®ããŠããã¹ããåãåºããŸãã
MID(text, start_num, num_chars)=MID("Excelåœæ°",1,5)è€æ°ã®ããã¹ããç¯å²ãé£çµããŸãã
CONCAT(text1, [text2], ...)=CONCAT(A1:A3)è€æ°ã®ããã¹ããé£çµããäºææ§é¢æ°ã§ãã
CONCATENATE(text1, [text2], ...)=CONCATENATE("Excel","åŸå¥œçš")åºåãæåãšç©ºæ¬ã®æ±ããæå®ããŠããã¹ããé£çµããŸãã
TEXTJOIN(delimiter, ignore_empty, text1, ...)=TEXTJOIN(",",TRUE,A1:A5)æ°å€ãæžåŒæå®ããããã¹ãã«å€æããŸãã
TEXT(value, format_text)=TEXT(1234.5,"#,##0.00")æ°å€ãšããŠè§£éã§ããããã¹ããæ°å€ã«å€æããŸãã
VALUE(text)=VALUE("123")åèªéã®1åãé€ãéåžžã®ã¹ããŒã¹ãåãé€ããŸãã
TRIM(text)=TRIM(" Hello World ")å é 32çš®é¡ã®ASCIIå¶åŸ¡æåãåãé€ããŸãããã¹ãŠã®Unicodeå¶åŸ¡æåãé€å»ãããã®ã§ã¯ãããŸããã
CLEAN(text)=CLEAN(A1)ããã¹ãã®è±åã倧æåã«ããŸãã
UPPER(text)=UPPER("toolkk")ããã¹ãã®è±åãå°æåã«ããŸãã
LOWER(text)=LOWER("TOOLKK")åèªã®å é ã倧æåããã®ä»ãå°æåã«ããŸãã
PROPER(text)=PROPER("hello world")倧尿åãåºå¥ããŠäžèŽããããã¹ãã®éå§äœçœ®ãæ¢ããŸãã
FIND(find_text, within_text, [start_num])=FIND("k","Toolkk")倧尿åãåºå¥ããã«éå§äœçœ®ãæ¢ããŸããã¯ã€ã«ãã«ãŒãã䜿ããŸãã
SEARCH(find_text, within_text, [start_num])=SEARCH("e","Excel")æå®ããããã¹ããå¥ã®ããã¹ãã«çœ®ãæããŸãã
SUBSTITUTE(text, old_text, new_text, [instance_num])=SUBSTITUTE("2024-01-01","-","/")äœçœ®ãšæåæ°ãæå®ããŠããã¹ãã®äžéšã眮ãæããŸãã
REPLACE(old_text, start_num, num_chars, new_text)=REPLACE("abcdef",2,3,"XYZ")ããã¹ããæå®ããåæ°ã ãç¹°ãè¿ããŸãã
REPT(text, number_times)=REPT("-",5)倧尿åãåºå¥ããŠ2ã€ã®ããã¹ããæ¯èŒããŸãã
EXACT(text1, text2)=EXACT("Excel","excel")æå®ããæ°å€ãåèšããŸãã
SUM(number1, [number2], ...)=SUM(A1:A10)1ã€ã®æ¡ä»¶ã«åãã»ã«ã®å€ãåèšããŸãã
SUMIF(range, criteria, [sum_range])=SUMIF(B:B,">100",C:C)è€æ°ã®æ¡ä»¶ã«åãã»ã«ã®å€ãåèšããŸãã
SUMIFS(sum_range, criteria_range1, criteria1, ...)=SUMIFS(C:C,A:A,"éå®",B:B,">100")é åã®å¯Ÿå¿ããèŠçŽ ã®ç©ãåèšããŸãã
SUMPRODUCT(array1, [array2], ...)=SUMPRODUCT(A1:A5,B1:B5)æå®ããæ°å€ãæãåãããŸãã
PRODUCT(number1, [number2], ...)=PRODUCT(2,3,4)æ°å€ã®çµ¶å¯Ÿå€ãèšç®ããŸãã
ABS(number)=ABS(-12)æå®ããæ¡ã§åæšäºå ¥ããŸãã
ROUND(number, num_digits)=ROUND(3.1415,2)æå®ããæ¡ã§ãŒãããé ãããæ¹åã«äžžããŸãã
ROUNDUP(number, num_digits)=ROUNDUP(3.111,1)æå®ããæ¡ã§ãŒãã«è¿ã¥ãæ¹åã«äžžããŸãã
ROUNDDOWN(number, num_digits)=ROUNDDOWN(3.199,1)æ°å€ä»¥äžã®æŽæ°ãžäžžããŸããè² ã®æ°ã§ã¯ãŒãããé ãããå ŽåããããŸãã
INT(number)=INT(-1.5)é€ç®ã®äœããèšç®ããŸãã
MOD(number, divisor)=MOD(10,3)æå®ããææ°ã®ã¹ãä¹ãèšç®ããŸãã
POWER(number, power)=POWER(2,10)éè² ã®æ°ã®å¹³æ¹æ ¹ãèšç®ããŸãã
SQRT(number)=SQRT(16)èªç¶å¯Ÿæ°ã®åºeã®ã¹ãä¹ãèšç®ããŸãã
EXP(number)=EXP(1)æ£ã®æ°ã®èªç¶å¯Ÿæ°ãèšç®ããŸãã
LN(number)=LN(2.71828)æå®ããåºã®å¯Ÿæ°ãèšç®ããŸãã
LOG(number, [base])=LOG(1000,10)0以äž1æªæºã®ä¹±æ°ãçæããŸããåèšç®ã§å€ãããŸãã
RAND()=RAND()æå®ããäžéãšäžéã®éã®æŽæ°ãã©ã³ãã ã«çæããŸãã
RANDBETWEEN(bottom, top)=RANDBETWEEN(1,100)æå®ããåºæ°ã®åæ°ãžäžžããŸãã笊å·ãšäºææ§é¢æ°ã®ä»æ§ã«æ³šæããŸãã
CEILING(number, significance)=CEILING(7,5)æå®ããåºæ°ã®åæ°ãžäžžããŸããè² æ°ã®æ±ãã¯é¢æ°ã®ä»æ§ã確èªããŸãã
FLOOR(number, significance)=FLOOR(7,5)æ°å€ã®ç®è¡å¹³åãèšç®ããŸãã
AVERAGE(number1, [number2], ...)=AVERAGE(A1:A10)1ã€ã®æ¡ä»¶ã«åãå€ã®å¹³åãèšç®ããŸãã
AVERAGEIF(range, criteria, [average_range])=AVERAGEIF(B:B,">60",C:C)è€æ°ã®æ¡ä»¶ã«åãå€ã®å¹³åãèšç®ããŸãã
AVERAGEIFS(average_range, criteria_range1, criteria1, ...)=AVERAGEIFS(C:C,A:A,"éå®",B:B,">100")æ°å€ãå«ãã»ã«ãæ°ããŸãã
COUNT(value1, [value2], ...)=COUNT(A1:A100)空ã§ãªãã»ã«ãæ°ããŸãã空æååãè¿ãæ°åŒã察象ã§ãã
COUNTA(value1, [value2], ...)=COUNTA(A1:A100)空çœã®ã»ã«ãæ°ããŸãã空æååãè¿ãæ°åŒã察象ã§ãã
COUNTBLANK(range)=COUNTBLANK(A1:A100)1ã€ã®æ¡ä»¶ã«åãã»ã«ãæ°ããŸãã
COUNTIF(range, criteria)=COUNTIF(A:A,"已宿")è€æ°ã®æ¡ä»¶ã«åãã»ã«ãæ°ããŸãã
COUNTIFS(criteria_range1, criteria1, ...)=COUNTIFS(A:A,"éå®",B:B,">100")æ°å€ã®æå€§å€ãæ±ããŸãã
MAX(number1, [number2], ...)=MAX(A1:A10)æ°å€ã®æå°å€ãæ±ããŸãã
MIN(number1, [number2], ...)=MIN(A1:A10)è€æ°ã®æ¡ä»¶ã«åãã»ã«ã®æå€§å€ãæ±ããŸãã
MAXIFS(max_range, criteria_range1, criteria1, ...)=MAXIFS(C:C,A:A,"éå®")è€æ°ã®æ¡ä»¶ã«åãã»ã«ã®æå°å€ãæ±ããŸãã
MINIFS(min_range, criteria_range1, criteria1, ...)=MINIFS(C:C,A:A,"éå®")æ°å€ã®äžå€®å€ãèšç®ããŸãã
MEDIAN(number1, [number2], ...)=MEDIAN(A1:A10)æãé »ç¹ã«çŸããæ°å€ãæ±ããäºææ§é¢æ°ã§ãã
MODE(number1, [number2], ...)=MODE(A1:A10)æšæ¬ã®æšæºåå·®ãæšå®ããäºææ§é¢æ°ã§ãã
STDEV(number1, [number2], ...)=STDEV(A1:A10)æšæ¬ã®åæ£ãæšå®ããäºææ§é¢æ°ã§ãã
VAR(number1, [number2], ...)=VAR(A1:A10)æ°å€ãäžèЧå ã§å ããé äœãæ±ããäºææ§é¢æ°ã§ãã
RANK(number, ref, [order])=RANK(B2,B$2:B$10,0)倧ããæ¹ããæå®ããé äœã®æ°å€ãæ±ããŸãã
LARGE(array, k)=LARGE(A1:A10,2)å°ããæ¹ããæå®ããé äœã®æ°å€ãæ±ããŸãã
SMALL(array, k)=SMALL(A1:A10,3)æå®ããå²åã®ããŒã»ã³ã¿ã€ã«ãæ±ããäºææ§é¢æ°ã§ãã
PERCENTILE(array, k)=PERCENTILE(A1:A100,0.9)çŸåšã®æ¥ä»ãè¿ããŸããåèšç®æã«æŽæ°ãããŸãã
TODAY()=TODAY()çŸåšã®æ¥æãè¿ããŸããåèšç®æã«æŽæ°ãããŸãã
NOW()=NOW()å¹Žã»æã»æ¥ããExcelã®æ¥ä»å€ãäœããŸãã
DATE(year, month, day)=DATE(2026,5,20)æã»åã»ç§ããExcelã®æå»å€ãäœããŸãã
TIME(hour, minute, second)=TIME(14,30,0)æ¥ä»å€ãã幎ãåãåºããŸãã
YEAR(serial_number)=YEAR("2026-05-20")æ¥ä»å€ããæãåãåºããŸãã
MONTH(serial_number)=MONTH("2026-05-20")æ¥ä»å€ããæå ã®æ¥ãåãåºããŸãã
DAY(serial_number)=DAY("2026-05-20")æå»å€ããæãåãåºããŸãã
HOUR(serial_number)=HOUR("14:30:00")æå»å€ããåãåãåºããŸãã
MINUTE(serial_number)=MINUTE("14:30:00")æå»å€ããç§ãåãåºããŸãã
SECOND(serial_number)=SECOND("14:30:25")ææ¥ãæå®æ¹åŒã®æŽæ°ã§è¿ããŸãã
WEEKDAY(serial_number, [return_type])=WEEKDAY(TODAY(),2)æ¥ä»ã®é±çªå·ãæ±ããŸããé±ã®éå§ãšæ¹åŒã«äŸåããŸãã
WEEKNUM(serial_number, [return_type])=WEEKNUM("2026-05-20")2ã€ã®æ¥ä»ã®ééãæå®ããåäœã§èšç®ããŸãã
DATEDIF(start_date, end_date, unit)=DATEDIF(A1,B1,"Y")éå§æ¥ããæå®ããææ°ã ãååŸã®æ¥ä»ãæ±ããŸãã
EDATE(start_date, months)=EDATE(TODAY(),3)æå®ããææ°ã ãååŸã®ææ«æ¥ãæ±ããŸãã
EOMONTH(start_date, months)=EOMONTH(TODAY(),0)åæ¥ãšæå®ããäŒæ¥ãé€ããŠæéå ã®çšŒåæ¥ãæ°ããŸãã
NETWORKDAYS(start_date, end_date, [holidays])=NETWORKDAYS(A1,B1,H1:H10)åæ¥ãšæå®ããäŒæ¥ãé€ããæå®ããçšŒåæ¥æ°ã ãååŸã®æ¥ä»ãæ±ããŸãã
WORKDAY(start_date, days, [holidays])=WORKDAY(TODAY(),10)çµäºæ¥ãšéå§æ¥ã®å·®ã®æ¥æ°ãèšç®ããŸãã
DAYS(end_date, start_date)=DAYS("2026-12-31","2026-01-01")ç¯å²ã®å é åã§æ€çŽ¢ããåãè¡ã®æå®åã®å€ãååŸããŸãã
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])=VLOOKUP(A2,Sheet2!A:D,3,FALSE)ç¯å²ã®å é è¡ã§æ€çŽ¢ããåãåã®æå®è¡ã®å€ãååŸããŸãã
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])=HLOOKUP("å§å",A1:F10,3,FALSE)æ€çŽ¢ç¯å²ã«å¯Ÿå¿ããæ»ãç¯å²ããå€ãååŸããŸãã
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])=XLOOKUP(A2,Sheet2!A:A,Sheet2!C:C,"æªæŸå°")æé ã®æ€çŽ¢ç¯å²ã§å€ãæ¢ããŠå¯Ÿå¿ããçµæãååŸããŸãã
LOOKUP(lookup_value, lookup_vector, [result_vector])=LOOKUP(85,{0,60,80,90},{"å·®","äž","è¯","äŒ"})ç¯å²å ã§æ¡ä»¶ã«åãé ç®ã®äœçœ®ãæ±ããŸãã
MATCH(lookup_value, lookup_array, [match_type])=MATCH("åŒ äž",A1:A100,0)è¡ã»åãæå®ããŠç¯å²å ã®å€ãåç §ãååŸããŸãã
INDEX(array, row_num, [column_num])=INDEX(A1:D10,3,2)åç §ã衚ãããã¹ããå®éã®åç §ã«å€æããŸãã
INDIRECT(ref_text, [a1])=INDIRECT("A"&B1)éå§åç §ããã®è¡ã»åã®ãããšå€§ããã§åç §ãäœããŸãã
OFFSET(reference, rows, cols, [height], [width])=OFFSET(A1,2,1,3,2)åç §ã®è¡çªå·ãæ±ããŸãã
ROW([reference])=ROW(A5)åç §ã®åçªå·ãæ±ããŸãã
COLUMN([reference])=COLUMN(C1)ç¯å²ã®è¡æ°ãæ°ããŸãã
ROWS(array)=ROWS(A1:A10)ç¯å²ã®åæ°ãæ°ããŸãã
COLUMNS(array)=COLUMNS(A1:D1)çªå·ã§æå®ããåè£ã®å€ãååŸããŸãã
CHOOSE(index_num, value1, [value2], ...)=CHOOSE(2,"红","é»","è")æå®ããå Žæãžã®ãªã³ã¯ãäœæããŸãã
HYPERLINK(link_location, [friendly_name])=HYPERLINK("https://toolkk.com","Toolkk")æ¡ä»¶ã«åãé åã®èŠçŽ ãæœåºããŸãã
FILTER(array, include, [if_empty])=FILTER(A2:C100,B2:B100>60,"æ ")é åããäžæã®å€ãåãåºããŸãã
UNIQUE(array, [by_col], [exactly_once])=UNIQUE(A2:A100)é åã®æå®ããåãŸãã¯è¡ãããŒã«äžŠã¹æ¿ããŸãã
SORT(array, [sort_index], [sort_order], [by_col])=SORT(A2:C100,2,-1)æ¡ä»¶ã«ãã£ãŠè¿ãå€ãåãæ¿ããŸãã
IF(logical_test, value_if_true, [value_if_false])=IF(A1>=60,"åæ Œ","äžåæ Œ")å ã«æç«ããæ¡ä»¶ã«å¯Ÿå¿ããå€ãè¿ããŸãã
IFS(condition1, value1, condition2, value2, ...)=IFS(A1>=90,"äŒ",A1>=60,"åæ Œ",TRUE,"äžåæ Œ")ãã¹ãŠã®æ¡ä»¶ãçãã確èªããŸãã
AND(logical1, [logical2], ...)=AND(A1>0,A1<100)å°ãªããšã1ã€ã®æ¡ä»¶ãçãã確èªããŸãã
OR(logical1, [logical2], ...)=OR(A1="æ¯",B1="æ¯")è«çå€ãå転ããŸãã
NOT(logical)=NOT(TRUE)çã§ããåŒæ°ã®åæ°ã奿°ã®å Žåã«TRUEãè¿ããŸãã
XOR(logical1, [logical2], ...)=XOR(TRUE,FALSE)ãšã©ãŒæã«ä»£ããã®å€ãè¿ããŸãã
IFERROR(value, value_if_error)=IFERROR(A1/B1,0)#N/Aã®å Žåã«ä»£ããã®å€ãè¿ããŸãã
IFNA(value, value_if_na)=IFNA(VLOOKUP(A1,B:C,2,FALSE),"æªæŸå°")åŒã«äžèŽããåè£ã®çµæãè¿ããŸãã
SWITCH(expression, value1, result1, ..., [default])=SWITCH(A1,1,"äž",2,"äº","å
¶ä»")äžå®ã®å©çãšæ¯æåæ°ããåæã®å®é¡æ¯æé¡ãèšç®ããŸãã
PMT(rate, nper, pv, [fv], [type])=PMT(0.05/12,360,-1000000)äžå®ã®å©çãšå®ææ¯æããçšããŠå°æ¥äŸ¡å€ãèšç®ããŸãã
FV(rate, nper, pmt, [pv], [type])=FV(0.04,10,-2000)äžå®ã®å©çã§å°æ¥ã®æ¯æãã®çŸåšäŸ¡å€ãèšç®ããŸãã
PV(rate, nper, pmt, [fv], [type])=PV(0.05,10,-1000)åææ«ã®ãã£ãã·ã¥ãããŒãå²ãåŒããŠåèšããŸããæç¹0ã®åææè³ã¯å€åŽã§å ããŸãã
NPV(rate, value1, [value2], ...)=NPV(0.1,300,400,500,600)-1000çééã®ãã£ãã·ã¥ãããŒã®å éšåççãæ±ããŸãã
IRR(values, [guess])=IRR(A1:A6)æ¯æåæ°ã»éé¡ãªã©ãã1æãããã®å©çãæ±ããŸãã
RATE(nper, pmt, pv, [fv], [type], [guess])=RATE(36,-300,10000)*12äžå®å©çãšæ¯æãæ¡ä»¶ããå¿ èŠãªææ°ãæ±ããŸãã
NPER(rate, pmt, pv, [fv], [type])=NPER(0.05/12,-1000,200000)åç §å ã空ã®ã»ã«ãã確èªããŸãã
ISBLANK(value)=ISBLANK(A1)å€ãæ°å€ãã確èªããŸãã
ISNUMBER(value)=ISNUMBER(A1)å€ãããã¹ããã確èªããŸãã
ISTEXT(value)=ISTEXT(A1)å€ããšã©ãŒãã確èªããŸãã
ISERROR(value)=ISERROR(A1/B1)å€ã#N/Aãã確èªããŸãã
ISNA(value)=ISNA(VLOOKUP(A1,B:C,2,FALSE))æ°å€ãå¶æ°ãã確èªããŸãã
ISEVEN(number)=ISEVEN(4)æ°å€ã奿°ãã確èªããŸãã
ISODD(number)=ISODD(3)å€ã®åã衚ãçªå·ãååŸããŸãã
TYPE(value)=TYPE(A1)#N/Aã®ãšã©ãŒå€ãäœããŸãã
NA()=NA()ã»ã«ã®äœçœ®ã»æžåŒãªã©æå®ããçš®é¡ã®æ å ±ãååŸããŸãã
CELL(info_type, [reference])=CELL("address",A1)æå®ããå®è¡ç°å¢ã®æ å ±ãååŸããŸãã
INFO(type_text)=INFO("osversion")æ¡ä»¶ç¯å²ã«åãããŒã¿ããŒã¹ã®æ°å€ãåèšããŸãã
DSUM(database, field, criteria)=DSUM(A1:D100,"éé¢",F1:G2)æ¡ä»¶ç¯å²ã«åãããŒã¿ããŒã¹ã®æ°å€ã®å¹³åãèšç®ããŸãã
DAVERAGE(database, field, criteria)=DAVERAGE(A1:D100,"åæ°",F1:G2)æ¡ä»¶ç¯å²ã«åãããŒã¿ããŒã¹ã®æ°å€ãæ°ããŸãã
DCOUNT(database, field, criteria)=DCOUNT(A1:D100,"åæ°",F1:G2)æ¡ä»¶ç¯å²ã«åãããŒã¿ããŒã¹ã®ç©ºã§ãªãå€ãæ°ããŸãã
DCOUNTA(database, field, criteria)=DCOUNTA(A1:D100,"å§å",F1:G2)æ¡ä»¶ã«äžèŽããå¯äžã®ã¬ã³ãŒãããå€ãåãåºããŸãã
DGET(database, field, criteria)=DGET(A1:D100,"å§å",F1:G2)æ¡ä»¶ã«åãããŒã¿ããŒã¹ã®æå€§å€ãæ±ããŸãã
DMAX(database, field, criteria)=DMAX(A1:D100,"éé¢",F1:G2)æ¡ä»¶ã«åãããŒã¿ããŒã¹ã®æå°å€ãæ±ããŸãã
DMIN(database, field, criteria)=DMIN(A1:D100,"éé¢",F1:G2)2鲿°ã®è¡šçŸã10鲿°ã«å€æããŸãã
BIN2DEC(number)=BIN2DEC(1010)10鲿°ã2鲿°ã®ããã¹ãã«å€æããŸãã
DEC2BIN(number, [places])=DEC2BIN(10)10鲿°ã16鲿°ã®ããã¹ãã«å€æããŸãã
DEC2HEX(number, [places])=DEC2HEX(255)16鲿°ã®è¡šçŸã10鲿°ã«å€æããŸãã
HEX2DEC(number)=HEX2DEC("FF")æŽæ°ã®ãããããšã®ANDãèšç®ããŸãã
BITAND(number1, number2)=BITAND(5,3)æŽæ°ã®ãããããšã®ORãèšç®ããŸãã
BITOR(number1, number2)=BITOR(5,3)æŽæ°ã®ãããããšã®XORãèšç®ããŸãã
BITXOR(number1, number2)=BITXOR(5,3)æå®ããæž¬å®åäœã®éã§æ°å€ãæç®ããŸãã
CONVERT(number, from_unit, to_unit)=CONVERT(1,"km","m")ããããããŒãã«ã®æå®ããéèšå€ãååŸããŸãã
GETPIVOTDATA(data_field, pivot_table, [field1, item1], ...)=GETPIVOTDATA("éé¢",A3,"å°åº","åäž")åç §å ã®æ°åŒãããã¹ããšããŠååŸããŸãã
FORMULATEXT(reference)=FORMULATEXT(B2)æå®ããã·ãŒãã®çªå·ãæ±ããŸãã
SHEET([value])=SHEET()åç §å ã®ã·ãŒãæ°ãæ°ããŸãã
SHEETS([reference])=SHEETS()ãšã©ãŒãéè¡šç€ºã®æ±ããæå®ããŠéèšããŸãã
AGGREGATE(function_num, options, ref1, [ref2], ...)=AGGREGATE(9,6,A1:A10)ãã£ã«ã¿ãŒç¶æ ãèæ ®ããŠç¯å²ãéèšããŸãã
SUBTOTAL(function_num, ref1, [ref2], ...)=SUBTOTAL(9,A2:A100)䜿çšããæåã»ããã®ã³ãŒãã«å¯Ÿå¿ããæåãè¿ããŸãã
CHAR(number)=CHAR(65)å é ã®æåã®äœ¿çšæåã»ããäžã®ã³ãŒããè¿ããŸãã
CODE(text)=CODE("A")æŠèŠ
解決ã§ãã課é¡ãåŠçã®ä»çµã¿ãããŒã¿ã®ç¯å²ã確èªã§ããŸãã
Excel 颿°ã®åè衚ã§ããåé²ããã146ä»¶ã«ã€ããŠãæ¥æ¬èªã®çšé説æãã«ããŽãªãè±åã®é¢æ°åãæ§æã䜿çšäŸãæ€çŽ¢ã§ããŸãã颿°åãåãããªããšãã¯ãè€æ°æ¡ä»¶ã§åèšãã®ãããªçšéèªãããååãç¥ã£ãŠãããšã㯠SUMIFS ã VLOOKUP ãã調ã¹ãããŸããæ€çŽ¢å¯Ÿè±¡ã¯é¢æ°åã»èª¬æã»æ§æã»äŸã»è£è¶³ã§ãçµæã«ã¯è©²åœä»¶æ°ãšå颿°ã®æ
å ±ã衚瀺ãããŸãã
ããã¯é¢æ°ãæ¢ãããã®äžèЧã§ãããã¯ãèªã¿èŸŒãã ããã»ã«ã®å€ã䜿ã£ãŠæ°åŒãå®è¡ãããããæ©èœã§ã¯ãããŸããã説æãäŸãææããã«åŒãçµã¿ç«ãŠãå®éã®è¡šèšç®ãœããã§çµæã確ãããŸãã
颿°åã®åŸã®æ¬åŒ§å
ã«äžŠã¶èªã¯åŒæ°ã§ããããšãã° SUMIFS(sum_range, criteria_range1, criteria1, ...) ã§ã¯ãæåã«åèšå¯Ÿè±¡ã®ç¯å²ãæå®ãããã®åŸã«æ¡ä»¶ç¯å²ãšæ¡ä»¶ãçµã¿åãããŸããè§æ¬åŒ§ã§å²ãŸããåŒæ°ã¯çç¥å¯èœã衚ãèšæ³ã§ãçç¥ã§ããæ¡ä»¶ãé åºã¯é¢æ°ããšã«ç°ãªããŸããçç¥èšå·ã¯åãçš®é¡ã®åŒæ°ãç¶ããŠæå®ã§ããããšã瀺ããŸãã
çšé説æã¯é¢æ°éžã³ã®å ¥å£ãšããŠäœ¿ãã现ããªåŒæ°ã®æå³ãçããšã®å¯Ÿå¿ç¶æ³ã¯å ¬åŒè³æã§ç¢ºèªããŠãã ãããMicrosoft ã®æ©èœå¥äžèЧã§ã¯åé¡ãšé¢æ°æ å ±ãç §åã§ãã颿°ãæ°åŒã«å ¥ããåºæ¬æé ãå ¬åŒãã«ãã§ç¢ºèªã§ããŸãã
äœ¿ãæ¹
æé ã«æ²¿ã£ãŠæäœããäŸã䜿ã£ãŠå ¥åãšçµæã確èªããŸãã
颿°åã®ã»ãããæ¡ä»¶ä»ãã®åèšããæ¥ä»ããæååããªã©ã®çšéããæ§æã®äžéšãæ€çŽ¢æ¬ã«å ¥ããŸããæ€çŽ¢ã¯åé²èšé²ã®èª¬æã»äŸã»è£è¶³ã察象ã«ããŸãã
ããã¹ããæ°åŠãçµ±èšãæ¥ä»ãšæå»ãæ€çŽ¢ãšåç §ãè«çã財åãªã©ããã«ããŽãªãæå®ããŸããåè£ãèŠã€ãããªãå Žåã¯ããã¹ãŠãã«æ»ããå¥ã®èªã颿°åã§è©ŠããŠãã ããã
åè£ã®é¢æ°åãçšéãåŒæ°é ã確èªããäŸã«ããç¯å²ãæ¡ä»¶ãèªåã®è¡šã«çœ®ãæããŸããååã»æ§æã»äŸã¯ããããã³ããŒã§ããŸãã貌ãä»ãåŸãæ°åŒã®åºåãèšå·ãã»ã«åç §ãå©çšç°å¢ã«åãããŠç¢ºèªããŸãã
ããšãã°éšçœ²åãšéé¡ã®äž¡æ¹ã§éèšãããå Žåã¯ãè€æ°æ¡ä»¶ åèšããŸã㯠SUMIFS ãæ€çŽ¢ããåèšç¯å²ãå
é ã®åŒæ°ã§ããããšãæ¡ä»¶ç¯å²ãšæ¡ä»¶ã察ã«ãªã£ãŠããããšã確èªããŸãã
掻çšäŸ
ä»äºãæ¥åžžã®æµãã®äžã§ã®æŽ»ç𿹿³ã玹ä»ããŸãã
æ
åœè
ãåååºåããšã®éé¡ããŸãšãããšããæ€çŽ¢èªãã SUMIF ãš SUMIFS ãæ¢ããæ¡ä»¶ã®æ°ãšåŒæ°é ãæ¯èŒããŸããåç¯å²ãèªåã®è¡šã«çœ®ãæããåŸãåèšãæå³ããè¡ã ãã察象ã«ããã確èªããŸãã
瀟å¡çªå·ãªã©ãææããã«å¥åã®æ å ±ãåç §ããããšããæ€çŽ¢ã»åç §ã«ããŽãªãã颿°ã調ã¹ãŸããæ€çŽ¢å€ã®ããåãè¿ãããå€ã®åãèŠã€ãããªãå Žåã®æ±ããæŽçããŠããåŒãéžã³ãŸãã
ææ«æ¥ãææ¥ãæåã®äžéšæœåºãªã©ãæ±ããšããæ¥ä»ãšæå»ãŸãã¯ããã¹ãã«ããŽãªãéžã³ãŸããäŸã®å ¥åå€ãšèªåã®ã»ã«åœ¢åŒãäžèŽãããã確èªããæ¥ä»ã®è§£éã衚瀺圢åŒã¯äœ¿çšäžã®è¡šèšç®ãœããã§è©ŠããŸãã
Q&A
ããããçåãè¿·ããããç¹ããŸãšããŠç¢ºèªã§ããŸãã
æ¥æ¬èªã®çšé説æãè£è¶³ã«å«ãŸããèªã§ãæ€çŽ¢ã§ããŸããåè£ãå€ãå Žåã¯ã«ããŽãªãéžã³ã颿°åãåãã£ããè±ååã§çµã蟌ãã§ãã ããã
ãã¹ãŠã®é¢æ°ãå šããŒãžã§ã³ã§äœ¿ããããã§ã¯ãããŸãããç¹ã«æ°ãã颿°ãåçé å颿°ã¯ã䜿çšãã Excel ã®çãšå ¬åŒã®å¯Ÿå¿æ å ±ã確èªããŠãã ããã
ãäžèŽãã颿°ãèŠã€ãããªãããšè¡šç€ºãããããã«ããŽãªãããã¹ãŠãã«ããŠãçšéèªãçãããã颿°åã®äžéšã詊ããŸãããã®äžèЧã«åé²ãããŠããªã颿°ã¯æ€çŽ¢çµæã«åºãŸããã
åŒæ°ãåºåãèšå·ã¯å°åèšå®ãªã©ã«ãã£ãŠç°ãªãå ŽåããããŸããåŒã®æ§é ãšåŒæ°é ãä¿ã£ããŸãŸãå©çšç°å¢ã®æ°åŒå ¥åã«è¡šç€ºãããåºåãæ¹ã«åãããŠãã ããã
泚æ
å©çšç¯å²ãçµæã®å¶éãå¿ èŠãªæ³šæç¹ãäºåã«ç¢ºèªããŸãã
ããã«è¡šç€ºãããã®ã¯146ä»¶ã®é¢æ°ã察象ã«ããåèæ å ±ã§ãExcel ã®å šé¢æ°ãç¶²çŸ ããäžèЧã§ã¯ãããŸããã説æã»æ§æã»äŸã¯é¢æ°ãéžã¶ææããã§ããåã ã®äŸãå®è¡ããçµæãããã¹ãŠã®çã»å°åèšå®ã§åãããã«åãããšãä¿èšŒãããã®ã§ã¯ãããŸããã
颿°ã®å©çšå¯åŠãæ¥ä»ã®è§£éãåŒæ°ã®åºåãã衚瀺圢åŒã¯ãExcel ã®çãå°åèšå®ã«ãã£ãŠå€ããããšããããŸããéèŠãªéèšãæ¥åäžã®å€æã«äœ¿ãåã«ã䜿çšäžã®ç°å¢ã§å°ããªãµã³ãã«ã詊ããMicrosoft ã®è©²åœé¢æ°ã®å ¬åŒè³æãšç §åããŠãã ããã
é¢é£
é¢é£ããŒã«ãç¹éãå©çšå¯èœãªAPIãæ¢ããŸãã