=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

podle
Tisk
Vložit

Výsledková tabule/Žebříček

Vizuální styl

Možnosti

Přepnout šablonu

Obnovit automatické uložení: ?