=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

さんの投稿です
印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?