Search any function by name, Microsoft category or real-world use case — syntax, arguments, translated examples, errors and tips in one place.
13 official Excel categories · real stats
By popularity score & most views
How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
How to use the IF function in Excel to make logical comparisons between data values.
Returns the value of an element in a table or an array, selected by the row and column number indexes. Use the array form if the first argument to INDEX is an array constant. Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of non-adjacent selections, you can pick the selection to look in.
Returns the largest value in a set of values.
Returns the smallest number in a set of values.
By your actual work — stats from 526 functions
Type a name or description — even part of it. 526 functions ready.