Excel-Formelgenerator

Adds all numbers in a range of cells.

Adds cells that meet a single condition.

Adds cells that meet multiple conditions.

Returns the arithmetic mean of numbers.

Counts cells containing numbers.

Counts non-empty cells.

Rounds a number to specified decimal places.

Rounds a number up, away from zero.

Rounds a number down, toward zero.

Returns the absolute value of a number.

Returns the remainder after division.

Returns number raised to a power.

Returns the square root of a number.

Multiplies all numbers together.

Returns integer portion of division.

Returns random number between 0 and 1.

Returns random integer in range.

Joins multiple text strings into one.

Joins text with a delimiter.

Returns characters from start of text.

Returns characters from end of text.

Returns characters from middle of text.

Returns the length of a text string.

Removes extra spaces from text.

Removes non-printable characters.

Converts text to uppercase.

Converts text to lowercase.

Capitalizes first letter of each word.

Replaces text within a string.

Replaces text at specific position.

Returns position of text (case-sensitive).

Returns position of text (case-insensitive).

Converts value to text with formatting.

Converts text to number.

Repeats text a given number of times.

Returns the current date.

Returns the current date and time.

Creates a date from year, month, day.

Extracts the year from a date.

Extracts the month from a date.

Extracts the day from a date.

Returns the day of the week.

Calculates difference between dates.

Returns date N months in future/past.

Returns last day of month N months away.

Returns date N workdays from start.

Counts business days between dates.

Searches first column and returns value.

Searches first row and returns value.

Flexible lookup function (Excel 365).

Returns value at intersection of row/column.

Returns relative position in range.

Returns reference specified by text.

Returns reference offset from starting point.

Returns value from list based on index.

Returns row number of reference.

Returns column number of reference.

Returns value based on condition.

Multiple IF conditions in sequence.

Returns TRUE if all conditions are true.

Returns TRUE if any condition is true.

Reverses the logic of argument.

Returns alternate value if error occurs.

Returns alternate value if #N/A error.

Matches expression against list of values.

Returns TRUE if odd number are true.

Counts cells matching a condition.

Counts cells matching multiple conditions.

Averages cells matching condition.

Returns the largest value.

Returns the smallest value.

Returns the k-th largest value.

Returns the k-th smallest value.

Returns the middle value.

Calculates standard deviation of sample.

Returns rank of number in list.

Returns k-th percentile of data.

Calculates periodic payment for loan.

Calculates future value of investment.

Calculates present value of investment.

Calculates net present value.

Calculates internal rate of return.

Calculates interest rate per period.

Calculates number of payment periods.

Returns unique values from range.

Sorts contents of range or array.

Filters range based on criteria.

Generates sequence of numbers.

Returns array of random numbers.

Rotates rows to columns and vice versa.

Assigns names to calculation results.

Creates custom reusable functions.

Returns TRUE if cell is empty.

Returns TRUE if value is any error.

Returns TRUE if value is #N/A error.

Returns TRUE if value is a number.

Returns TRUE if value is text.

Returns type of value as number.

Returns information about cell.

Returns system information.