=sum(A3:A5), To add the total of the cells., =max(A2:H9), To find the highest value in range, =min(A2:H9), To find the lowest value in the range, =average(A2:A9), To find the average value in the range, =median (A2:A9), To find the median value in the range, =Left(A1,3), To extract the first 3 characters from the left, =Left (A1,1), To extract the first character from the left, =mid(A2,3,2), To extract 2 characters starting from the 3rd one., =mid (A2,2, 3), To extract 3 characters starting from the 2nd one, =right(A1,2), To extract 2 characters from the right of the word in the cell, =VLOOKUP(D2,$D$29:$E$40, 2 ,false), To look up the value from the table D29:E40 that matches D2 and return the value in column 2, =VLOOKUP(D2,$D$29:$E$40, 4 ,false), To look up the value from the table D29:E40 that matches D2 and return the value in column 4, =count (A1:B50), To count the number of cells that contains numbers, =countA(A1:B50), To count the number of cells that are not blank, =countif(A1:B20,"Elderly"), To count the number of cells that contains the word Elderly., =today(), To return the current date, =NOW(), To return the current date and time, =if(D2>50,"y","n"), To return "y" if the content in cell D2 is greater than 50, =if(D2=50,"y","n"), To return "n" if the content in cell D2 is greater than 50, =round(D1,1), To round off the value in D1 to 1 decimal place., =roundup(D3,2), To round up the value in D3 to 2 decimal place.

Excel Functions

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?