Now that you have your data, you have to interpret it. Returns the smallest number in a set of values.Ĭounts the number of cells that contain numbers. Returns the largest value in a set of values. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. Returns the average (arithmetic mean) of the arguments. You can add individual values, cell references or ranges, or a mix of all three.
Microsoft excel 2007 tutorial basic full#
You can find the full list here and also here.Īdds values.
Functions, which are categorized by functionality, are just predefined formulas. What if you want to do more complex math though? How would you do it? Notice how I input the cell references instead of the actual numbers. Why? Because then you can’t copy and paste that formula into the remaining cells because the formula is hard-coded with numbers. You can do what I did above – input the exact numbers – but that isn’t the optimal solution. If you want to multiply two numbers, you’d use the “*” sign.Īnd if you want to divide two numbers, you’d use the “/” sign. If you want to subtract two numbers, you’d use the “-” sign. If you want to add two numbers, you’d use the “+” sign.
Scroll down and across your spreadsheet, and you’ll see that the information you need is always right there within view!