Discover how functions in Excel help you save time. These 11 chapters are your ideal starting point to master Excel functions!
Math and trigonometry: Returns an aggregate in a list or database ADDRESS Lookup and reference: Returns a reference as text to a single cell in a worksheet AMORDEGRC Financial: Returns the depreciation for each accounting period by using a depreciation coefficient AMORLINC Financial: Returns the...
Excel Functions List 2 of 7 Returns the serial number of the current date and time Converts a serial number to a second Returns the serial number of a particular time Converts a time in the form of text to a serial number Returns the serial number of today's date Converts a serial nu...
=CELL("format",C2) CELL Ex 2: Get Worksheet NameWith the "filename" value, the CELL function shows the file path, file name, and worksheet name.=CELL("filename",B2) From that result, you can use other functions to extract the worksheet name. ...
CELL function is a build-in Excel Info function. Cell function in Excel stores all the data of a referenced cell and returns the info_type of the cell.Syntax:=CELL (info_type, [reference])info_type : type of information about the referrence....
Insert the following formula in cellB11and pressEnterto get the product of 2 matrices: =MMULT(B6:D8,F6:H8) Case 13.3 – Check for Even or Odd We have a list ofnumbers.To check even or odd, we’ll use the combination ofIFandISEVENfunctions. ...
In this example, only the results for the subject entered in cell F2 are returned. =FILTER(B2:C12,A2:A12=F2,"No scores") Wrap up Learning the most useful Excel functions for data analysis mentioned in this article will go a long way to making Excel data analysis easier. But there are...
Acell referenceorcell addressis a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on. ...
There are two other error checking “is” functions:The ISNA Function returns TRUE only for #N/A errors. The ISERR Function returns TRUE for all errors except #N/A errors.=ISNA(A2) =ISERR(A2)Also, in addition to the IFERROR Function, there is the IFNA Function....
Latitute / Longitude Functions Replace Negative Values Reverse List Range Convert State Name to Abbreviation Create Dynamic Hyperlinks Custom Sort List with Formula Data Validation - Custom Formulas Dynamic Sheet Reference (INDIRECT) Reference Cell in Another Sheet or Workbook ...