Home » Excel » Functions

Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function is set to always round down. …

FLOOR Function Read More »

TRUNC

TRUNC Function

The TRUNC function in Excel returns a truncated number based on a specified number of digits. This specified number of digits is optional in Excel. What’s unique about …

TRUNC Function Read More »

ROUNDUP Function

ROUNDUP Function

The ROUNDUP function in Excel rounds numbers up a specified decimal place. This function rounds up all of the numbers. Syntax: =ROUNDUP (number,num_digits) Arguments: number – The number …

ROUNDUP Function Read More »

INT Function

The INT function in Excel rounds a number down to the nearest integer. This function will always round down. For negative numbers, if you have -14.5, the result …

INT Function Read More »

MROUND Function

MROUND Function

The MROUND function in Excel will round a number up or down to a given multiple.

Ceiling Function

CEILING Function

The CEILING function in Excel rounds a given number up to the nearest specified multiple.

WEEKDAY Function

WEEKDAY Function

The WEEKDAY Function in Excel returns an integer that represents a day of the week.

time value

TIMEVALUE Function

The TIMEVALUE function in Excel converts a time written as text into Excel time.

SECOND Function

The SECOND function in Excel returns the second component of a specified time as a number between 0-59. Syntax: =SECOND(serial_number) Arguments serial_number – (required) The time that contains …

SECOND Function Read More »

Scroll to Top