This tutorial covers the steps to creating a basic spreadsheet formula in Excel 2007/10. It is intended for those with little or no experience in working with spreadsheet programs such as Excel.
Excel 2007/10 formulas allow you to perform calculations on data entered into the spreadsheet.
You can use an Excel 2007/10 formula for basic number crunching, such as addition or subtraction, as well as more complex calculations such as payroll deductions or averaging a student’s test results.
In addition, if you change the data Excel will automatically recalculate the answer without you having to re-enter the formula.
MS excel contains 409 unique functions (like SUM, AVERAGE, COUNTIF, VLOOKUP)
Lets start with the basic arithmetic.
I would recommend, we start with SUM function.
Sum function adds all numbers in a range of cells and returns the result.
The syntax for the Sum function is:
Sum( number1, number2, … number_n )
or
Sum ( cell1:cell2 )
Examples:
As seen in the above example, I have selected a range of cells (A1 to A4), like wise, you can also select multiple range. Let see that in the next example.
E.g
Like the above example, you select n..number of range/cell for addition purpose.
Let me know, if you have any queries, regarding this function.
Remember: While working in Excel, ensure that you learn the basic/logic of any function.
What you can expect from my next post…
> Average & Countif Function
> Keyboard shortcuts (I hate mouse)
-
solks4excel posted this
