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 )
Sum ( cell1:cell2 )
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.
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)