WORKDAY Function
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values. For example, these values would be …
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
WEEKNUM Function
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to 52 representing the corresponding week …
ROUNDDOWN Function
The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.
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. …
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 …
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 …
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 …
ROUND Function
The ROUND function in Excel returns a number rounded to a given number of digits. This can be used to round a number to the right or left …
CEILING Function
The CEILING function in Excel rounds a given number up to the nearest specified multiple.