A function is a predefined formula that performs calculations using specific values in a particular order. Excel has many built-in functions. In another side, a formula is an expression which calculates the value of a cell. Every Excel formula starts with equal to (=) symbol.
 |
| Using of SUM function in Excel |
Uses of some Excel functions
SUM()
SUM() function is used to find the sum or addition value in a particular range of cells of an Excel worksheet.
e.g.,
=SUM(A1 : A5)
Here, the addition value or summation value will return from the cell A1 to A5.
SUMIF()
SUMIF() function is used to find the sum or addition value in a particular range of cells of an Excel worksheet, but according to some criteria i.e., on the the basis of user given condition.
e.g.,
=SUMIF(A1 : A5, ">50")
Here, from the range of cells A1 to A5 will be added but only those numbers, which are more than 50.
COUNT()
COUNT() function is used to find the total number of numbers are present in a particular range of cells of an Excel Worksheet.
e.g.,
=COUNT(A1 : A5)
Here, how many total numbers are present in the range of cells A1 to A5 will return.
Here, how many total numbers are present in the range of cells A1 to A5 will return.
MAX()
MAX() function returns the maximum number from a given range of cells.
e.g.,
=MAX(A1 : A5)
Here, the maximum number will return from the range of cells A1 to A5.
MIN()
MIN() function returns the minimum number from a given range of cells.
e.g.,
=MAX(A1 : A5)
Here, the minimum number will return from the range of cells A1 to A5.
AVERAGE()
AVERAGE() function is used to find the average in a given range of cells.
e.g.,
=AVERAGE(A1 : A5)
Here, the average will return from the range of cells A1 to A5.
PRODUCT()
PRODUCT() function is used to find the multiplication value or product value in a given range of cells.
e.g.,
=PRODUCT(A1 : A5)
Here, the multiplication value will return from the range of cells A1 to A5.
Excel functions | Part - 1
TODAY()
TODAY() function is used to return system current date.
e.g.,
=TODAY()
Here, the system current date will be displayed.
e.g.,
=TODAY()
Here, the system current date will be displayed.
NOW()
NOW() returns the system current data and time in a particular cell.
e.g.,
=NOW()
Here, the system current date and time will display in any cell, in
which you will apply this formula.
IF()
As IF() function is a logical function, it returns logical values i.e.,
either True value or False value on the basis of user given condition.
e.g.,
=IF(A5>=50,”Good”,”Bad”)
Here, If the value of A5 is more than or equal to 50, then Good will display, otherwise Bad will display.
PMT()
PMT() is a type of financial function in MS Excel. This function calculates the payment for a loan based on constant payments and a constant interest rate.
 |
| The Calculation of PMT() function |
On the above example, to find the Payable Amount we have used the following formula.
=PMT(B2/12, B3, B1)
AutoSum (Σ)
How to use AutoSum(Σ)
1. Select the cell that the sum will appear in that is outside the cluster of cells whose values will be added.
2. Click the AutoSum button (Greek letter sigma Σ) on the Formula tab.
Excel Functions | Part - 2
AutoSum (Σ)
The AutoSum command allows us to automatically return the results for range of cells for common function like SUM.
How to use AutoSum(Σ)
1. Select the cell that the sum will appear in that is outside the cluster of cells whose values will be added.
2. Click the AutoSum button (Greek letter sigma Σ) on the Formula tab.
3. Highlight the group of cells that will be summed.
4. Press the ENTER key on the keyboard or click the tick (✔) mark button on the Formula bar.
4. Press the ENTER key on the keyboard or click the tick (✔) mark button on the Formula bar.
Author
Hi, Its me Hafeez. A webdesigner, blogspot developer and UI/UX Designer. I am a certified Themeforest top Author and Front-End Developer. I'am business speaker, marketer, Blogger and Javascript Programmer.
0 Comments:
Post a Comment