 |
 |
 |
 |
 |
Sum: adds the values of the cells in the cell range
=sum (cell range)
Min: finds smallest value in cell range
=min(cell range)
Max: finds largest value in cell range
=max(cell range)
Average: averages the values in the cell range
=average(cell range)
IF: returns one value if the condition is true, a separate value if the condition is false. As with all functions, parameters are separated by commas (,).
=if(condition, value if true, value if false)
examples:
=if(A1=B3, 25, 0)
=if(G6 <> “big”, Sum(A1:G6), “hello)
=if(B3<15, 0, if(B3>100, “error”, 100)