HomeExcel Functions
Excel
Excel Functions are predefined and preset formulas that are used to perform various types of calculations and process data in a particular order and accordingly, return results.
The presence of these Functions makes MS Excel and spreadsheets one of the most powerful applications in the field of data processing. Further, sound knowledge and effective use of these functions save users from a lot of laborious work and profusions time. No doubt, mastery over Excel function in the present era can help you climb the corporate ladder very quickly.
Position EXCEL Functions
| Function | Description |
| COLUMN | Returns the column number of a cell reference. |
| COLUMNS | Returns the number of columns in an array. |
| ROW | Returns the row number of a cell reference. |
| ROWS | Returns the number of rows in an array. |
| MATCH | Searches for a value in a list and returns its position. |
Lookup Functions
| Function | Description |
| VLOOKUP | Lookup a value in the first column and return a value. |
| HLOOKUP | Lookup a value in the first row and return a value. |
| INDEX | Returns a value based on its column and row numbers. |
| CHOOSE | Chooses a value from a list based on its position number. |
Text Position Functions
| Function | Description |
| FIND | Locates the position of the text within a cell. Case-sensitive. |
| SEARCH | Locates the position of the text within a cell. Not Case-sensitive. |
Time Functions
Period Functions
| Function | Description |
| DATEVALUE | Converts a date stored as text into a valid date |
| DATE | Returns a date from the year, month, and day. |
| WORKDAY.INTL | The date n working days from a date, custom weekends. |
| WORKDAY | The date n working days from a date. |
| EDATE | Returns a date, n months away from a start date. |
| EOMONTH | Returns the last day of the month, n months away date. |
| Function | Description |
| DATEDIF | A number of days, months, or years between two dates. |
| DAYS | Returns the number of days between two dates. |
| DAYS360 | Returns days between 2 dates in a 360 day year. |
| YEARFRAC | Returns the fraction of a year between 2 dates. |
| NETWORKDAYS | A number of working days between 2 dates. |
| NETWORKDAYS.INTL | Working days between 2 dates, custom weekends. |
Conditional Excel Functions
| Function | Description |
| ISBLANK | Test if the cell is blank. Results in TRUE/FALSE |
| ISTEXT | Test if the cell is text. Results in TRUE/FALSE |
| ISODD | Test if the cell value is odd. Results in TRUE/FALSE |
| ISERR | Test if the cell value is an error, ignores #N/A. Results in TRUE/FALSE |
| ISERROR | Test if the cell value is an error. Results in TRUE/FALSE |
| ISEVEN | Test if the cell value is even. Results in TRUE/FALSE |
| ISFORMULA | Test if the cell is a formula. Results in TRUE/FALSE |
| ISLOGICAL | Test if the cell is logical (TRUE or FALSE). Results in TRUE/FALSE |
| ISNA | Test if the cell value is #N/A. Results in TRUE/FALSE |
| ISNUMBER | Test if the cell is a number. Results in TRUE/FALSE |
| Function | Description |
| IF | If the given condition is met then do something, otherwise, do something else |
| IFNA | If the result is an #NA error then do something else. |
| IFERROR | If the result is an error then do something else. |
AVANTAGEHeadquarters
Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.
Copyright by Excel Accountancy. All rights reserved.
Copyright by BoldThemes. All rights reserved.
