=min(A1:B13) - Finds the lowest number in a set of values, =max(A1:B13) - Finds the highest number in a set of values, =sum(A1:B13) - Finds the total of all cells added together, =Average(A1:B13) - Finds the average of all the cells, =Count(A1:B13) - Counts all the cells that contain numbers, =Counta(A1:B13) - Counts the cells that contain letters or numbers (does not include blank cells), =if(g3<10,"Pass","Fail") - Gives two options, if criteria is TRUE will display first option "pass" if its false will display second option "Fail"), =vlookup("amy",b2:c17,2,false) - Lookup for a specific item and return the value for a given column,

iGCSE - Spreadsheets Functions

由
打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？