It returns the amount of days between two dates based on a year of 12 months with 30 days. It is a method used for some calculations in the accounting business.
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
=ROUND(AVERAGE(A1:A100),2) The answer you may be looking for is a nested function, as one is inside another. ROUND is a math function and AVERAGE is a statistical function.
Function
In Excel Where are the various function categories stored on the Ribbon?
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
functions of excel
A nested if.
A nested formula is where one or more functions are placed inside another function to make a formula. For example you can write a formula where you put an IF function within an IF function and this would be a nested formula.
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.
A function can reference cells or named ranges in the function.
You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.