The ROUNDDOWN function

Rounds the input value down to the nearest number based on the number of decimal places indicated, with 0 returning a whole number

Math and trigonometryMatthew Di MinnoDecember 29, 2025Comment

The ROUNDUP function

Rounds the input value up to the nearest number based on the number of decimal places indicated, with 0 returning a whole number

Math and trigonometryMatthew Di MinnoDecember 29, 2025Comment

The ROUND function

Rounds the input value up or down to the nearest number based on the number of decimal places indicated, with 0 returning a whole number

Math and trigonometryMatthew Di MinnoDecember 29, 2025Comment

The XLOOKUP function

Searches for a value in one column, returning the value in the same position from a second column. A newer and stronger version of both VLOOKUP and HLOOKUP.

Lookup and referenceMatthew Di MinnoDecember 29, 2025Comment

The ISTEXT function

Returns a TRUE or FALSE value depending if the value resolves to a text string or not

InformationMatthew Di MinnoApril 28, 2020Comment

The ISODD function

Returns a TRUE or FALSE value depending if the value resolves to an odd number or not

InformationMatthew Di MinnoApril 27, 2020Comment

The ISNUMBER function

Returns a TRUE or FALSE value depending if the value resolves to a numeric value or not

InformationMatthew Di MinnoApril 26, 2020Comment

The ISNONTEXT function

Returns a TRUE or FALSE value depending if the selected value resolves to a non-text value or not

InformationMatthew Di MinnoApril 25, 2020Comment

The ISLOGICAL function

Returns a TRUE or FALSE value depending if the output value resolves to a logical value or not

InformationMatthew Di MinnoApril 24, 2020Comment

The ISFORMULA function

Returns a TRUE or FALSE value depending if the selected cell contains a formula or not

InformationMatthew Di MinnoApril 23, 2020Comment

The ISEVEN function

Returns a TRUE or FALSE value depending if the value is an even number or not

InformationMatthew Di MinnoApril 22, 2020Comment

The ISERROR function

Returns a TRUE or FALSE value depending if the input resolves to an error message or not

InformationMatthew Di MinnoApril 21, 2020Comment

The ISBLANK function

Returns a TRUE or FALSE value depending if the cell in question is blank or not

InformationMatthew Di MinnoApril 20, 2020Comment

The YEARFRAC function

Returns the year fraction representing the number of whole days between start_date and end_date

Date and TimeMatthew Di MinnoApril 19, 2020Comment

The YEAR function

Converts a serial number to a year

Date and TimeMatthew Di MinnoApril 18, 2020Comment

The WORKDAY function

Returns the serial number of the date before or after a specified number of workdays

Date and TimeMatthew Di MinnoApril 17, 2020Comment

The WEEKNUM function

Converts a serial number to a number representing where the week falls numerically with a year

Date and TimeMatthew Di MinnoApril 16, 2020Comment

The WEEKDAY function

Converts a serial number to a day of the week

Date and TimeMatthew Di MinnoApril 15, 2020Comment

The VLOOKUP function

Looks in the first column of an array and moves across the row to return the value of a cell

Lookup and referenceMatthew Di MinnoApril 14, 2020Comment

The TRIM function

Removes spaces from text

TextMatthew Di MinnoApril 13, 2020Comment