EXCEL BUILT - IN FUNCTIONS
There are six types of built - in functions in MS Excel . These functions are Financial Functions , Logical Functions , Text Functions , Text Functions , Date & Time Functions , Lookup & Reference Functions , Math & Trig Functions.
.png)
FORMULAS RIBBON
1.) FINANCIAL FUNCTIONS
- PMT : This function is used to calculating periodical installments for a loan at a constant interest rate.
- PV : This function is used for calculating the present value of a given loan as an investment amount at fixed rate of interest.
- FV : This function is used for calculating the future value of the current investment amount , calculation is dependent on the fixed rate of interest.
2.) LOGICAL FUNCTIONS
- IF : It makes a logical comparison between the value and the expected value.
- AND : This is basically a supportive function for making better logical comparisons . Its outcome goes TRUE keeping all the inputs TRUE and results FALSE if one or more inputs are FALSE.
- OR : This function is also a supportive logical function , but it works on the following basis of logic , its resultant outcome becomes TRUE if one or more inputs provides TRUE and result FALSE if all the inputs provided FALSE.
- IF : It makes a logical comparison between the value and the expected value.
- AND : This is basically a supportive function for making better logical comparisons . Its outcome goes TRUE keeping all the inputs TRUE and results FALSE if one or more inputs are FALSE.
- OR : This function is also a supportive logical function , but it works on the following basis of logic , its resultant outcome becomes TRUE if one or more inputs provides TRUE and result FALSE if all the inputs provided FALSE.
3.) TEXT FUNCTIONS
- CONCATENATE : It combines two or more text strings into one single cell.
- DOLLAR : It converts a number to text with a dollar sign as its prefix.
- CONCATENATE : It combines two or more text strings into one single cell.
- DOLLAR : It converts a number to text with a dollar sign as its prefix.
4.) DATE & TIME FUNCTIONS
- DATE : This function returns selected cells in a date ( mm/dd/yyyy -default ) format.
- MONTH : It results the name of the month , given any number between between 1 JANUARY to 12 DECEMBER.
- DATE : This function returns selected cells in a date ( mm/dd/yyyy -default ) format.
- MONTH : It results the name of the month , given any number between between 1 JANUARY to 12 DECEMBER.
5 .) LOOKUP & REFERENCE FUNCTIONS
- VLOOKUP : This is a very popular and important function . It refers to the value provided input in the leftmost column of given dataset in the form of selected cells and results with the value from the matching row of a selected column.
- MATCH : It returns with the relative position of the required value from an array that matches a specified value.
- VLOOKUP : This is a very popular and important function . It refers to the value provided input in the leftmost column of given dataset in the form of selected cells and results with the value from the matching row of a selected column.
- MATCH : It returns with the relative position of the required value from an array that matches a specified value.
6 .) MATH & TRIG FUNCTIONS
- SUM : It returns with the sum of the selected cells , given the selected cells are numerical values.
- PI : It resultant outcome is mathematical value of PI i.e . precisely till 15 decimal places.
- PRODUCT : These results in the multiplication of the selected cells , given those cells are numerical values.
- SUM : It returns with the sum of the selected cells , given the selected cells are numerical values.
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=Excel Built - in Functions){kind=link}
0 Comments