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 […]
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
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.