Excel functions in plain English

Rounds away from zero.

Rounds toward zero.

Returns the absolute value.

Returns a remainder after division.

Raises a number to a power.

Returns a positive square root.

Returns one result if a condition is true and another if false.

Tests conditions and returns the first matching result.

Returns TRUE if every condition is true.

Returns TRUE if any condition is true.

Reverses TRUE and FALSE.

Returns a fallback value if an expression errors.

Returns a fallback when the result is #N/A.

Names intermediate calculations in a formula.

Returns rows or columns that meet criteria.

Sorts an array.

Sorts an array based on another array.

Returns distinct values.

Looks up a value and returns the corresponding result.

Returns the position of a matching item.