HomeExcel Functions

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.
Excel Functions

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

Function  Description
TIME Converts a time stored as text into a valid time.
TIMEVALUE Converts a time stored as text into a valid time.
These functions return numbers from a valid excel time value.
Function  Description
SECOND Returns the second as a number (0-59)
MINUTE Returns the minute as a number (0-59)
HOUR Returns the hour as a number (0-23).

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.
Function  Description
DAY Returns the day as a number (1-31).
WEEKDAY Returns the day of the week as a number (1-7).
WEEKNUM Returns the week number in a year (1-52).
MONTH Returns the month as a number (1-12).
YEAR Returns the year.

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
https://excel-accountancy.com/wp-content/uploads/2019/04/img-footer-map.png
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.