=MAX(B2:B8) - Returns the largest value in the range B2 to B8, =MIN(B2:B8) - Returns the smallest value in the range B2 to B8, =SUM(B2:B8) - Returns the total adding up the values in the range B2 to B8, =AVERAGE(B2:B8) - Returns the mean average of the values in the range B2 to B8, =COUNT(B2:B8) - Returns the number of values in the range B2 to B8, =COUNTIF(B2:B8,"Pass") - Returns the number of values in the range B2 to B8 which contain the word "Pass", =MOD(B2,B3) - Returns the remainder when B3 is divided by B2, =IF(B2>B3,"Pass","Fail") - Will return "Pass" if B2 is greater than B3, otherwise will return "Fail", =VLOOKUP(B2,D1:F12,2) - Will look for the value in B2 in the cells D1 to F12 and return the value in the second column if it finds a match,

Leaderboard

Visual style

Options

Switch template

Continue editing: ?