=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

על ידי
הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?