Functions are built-in formulas. In Microsoft Excel it is denote as fx which is the Formulas tab in the Ribbon. There a a few of function: 1. To round off the number , =ROUND(number;num_digits) --> rounds a number to a specified number of digits 2. To sum up the number, =SUM(number1;number2;... ) or =C4+C5+C6 --> Adds all numbers in a range of cells 3.. =DATE(year;month;day) --> Returns the number that represents the date in Ms Excel date time code p/s correct me if i'm wrong =)
Function are built-in formulas . This fountion can be found in formulas tab in the ribbon . There is some category such as financial,date&time and statistical . There is a few function . 1.to get the average =AVERAGE(number1;number2;......) *returns the average(arithmetic mean) of its arguments , which can be in numbers or names , arrays or references that contain numbers.
2.DDM=DBB(cost;salvage;life;period;factor) *returns the depreciation of an asset for specified period using the double-declining balance method
3.NOT=NOT(logical) *changes FALSE to TRUE ,or TRUE to FALSE .
Function are built-in formulas . This fountion can be found in formulas tab in the ribbon . There is some category such as financial,date&time and statistical . There is a few function . 1.to get the average =AVERAGE(number1;number2;......) *returns the average(arithmetic mean) of its arguments , which can be in numbers or names , arrays or references that contain numbers.
2.DDM=DBB(cost;salvage;life;period;factor) *returns the depreciation of an asset for specified period using the double-declining balance method
3.NOT=NOT(logical) *changes FALSE to TRUE ,or TRUE to FALSE .
Function are built-in formulas . This fountion can be found in formulas tab in the ribbon . There is some category such as financial,date&time and statistical . There is a few function . 1.to get the average =AVERAGE(number1;number2;......) *returns the average(arithmetic mean) of its arguments , which can be in numbers or names , arrays or references that contain numbers.
2.DDM=DBB(cost;salvage;life;period;factor) *returns the depreciation of an asset for specified period using the double-declining balance method
3.NOT=NOT(logical) *changes FALSE to TRUE ,or TRUE to FALSE .
Function are built-in formulas. Formulas tab in the Ribbon. 1) Financial which is IRR to returns the internal rate of returns for a series of cash flows. =IRR(values;guess)
2) Date & Time which is DATE to returns the present the number that represents the date in Microsoft Excel date-time code. =DATE(year;month;day)
3) Logical which is NOT that changes FALSE to TRUE, or TRUE to FALSE =NOT(logical)
Function are built-in formulas. Function can be found in formula tab in the ribbon. 1. Date& time in formula as a DATE (year;month;day) - it is to returns the number that represents the date in Microsoft Excel date-time code 2. For logical formula in function AND (logical1;logical2...) - to checka whether all arguments are TRUE and return TRUE if all arguments are TRUE 3. for Statistical formula in MIN(number1;number2:...) - to returns the smallest number in a set of values.Ignores logical values and text.
Functions are built-in formulas. In Microsoft Excel it is denote as fx which is the Formulas tab in the Ribbon. There a a few of function:
ReplyDelete1. To round off the number , =ROUND(number;num_digits)
--> rounds a number to a specified number of digits
2. To sum up the number, =SUM(number1;number2;... ) or =C4+C5+C6
--> Adds all numbers in a range of cells
3.. =DATE(year;month;day)
--> Returns the number that represents the date in Ms Excel date time code
p/s correct me if i'm wrong =)
Function are built-in formulas . This fountion can be found in formulas tab in the ribbon . There is some category such as financial,date&time and statistical .
ReplyDeleteThere is a few function .
1.to get the average =AVERAGE(number1;number2;......)
*returns the average(arithmetic mean) of its arguments , which can be in numbers or names , arrays or references that contain numbers.
2.DDM=DBB(cost;salvage;life;period;factor)
*returns the depreciation of an asset for specified period using the double-declining balance method
3.NOT=NOT(logical)
*changes FALSE to TRUE ,or TRUE to FALSE .
Function are built-in formulas . This fountion can be found in formulas tab in the ribbon . There is some category such as financial,date&time and statistical .
ReplyDeleteThere is a few function .
1.to get the average =AVERAGE(number1;number2;......)
*returns the average(arithmetic mean) of its arguments , which can be in numbers or names , arrays or references that contain numbers.
2.DDM=DBB(cost;salvage;life;period;factor)
*returns the depreciation of an asset for specified period using the double-declining balance method
3.NOT=NOT(logical)
*changes FALSE to TRUE ,or TRUE to FALSE .
Function are built-in formulas . This fountion can be found in formulas tab in the ribbon . There is some category such as financial,date&time and statistical .
ReplyDeleteThere is a few function .
1.to get the average =AVERAGE(number1;number2;......)
*returns the average(arithmetic mean) of its arguments , which can be in numbers or names , arrays or references that contain numbers.
2.DDM=DBB(cost;salvage;life;period;factor)
*returns the depreciation of an asset for specified period using the double-declining balance method
3.NOT=NOT(logical)
*changes FALSE to TRUE ,or TRUE to FALSE .
Function are built-in formulas. Formulas tab in the Ribbon.
ReplyDelete1) Financial which is IRR to returns the internal rate of returns for a series of cash flows.
=IRR(values;guess)
2) Date & Time which is DATE to returns the present the number that represents the date in Microsoft Excel date-time code.
=DATE(year;month;day)
3) Logical which is NOT that changes FALSE to TRUE, or TRUE to FALSE
=NOT(logical)
Function are built-in formulas. Function can be found in formula tab in the ribbon.
ReplyDelete1. Date& time in formula as a DATE (year;month;day)
- it is to returns the number that represents the date in Microsoft Excel date-time code
2. For logical formula in function AND (logical1;logical2...)
- to checka whether all arguments are TRUE and return TRUE if all arguments are TRUE
3. for Statistical formula in MIN(number1;number2:...)
- to returns the smallest number in a set of values.Ignores logical values and text.