Function: ROUNDUP

Function: ROUNDUP

The ROUNDUP function rounds up a number to a specified number of digits or decimals. In this guide, we’re going to show you how to use the ROUNDUP function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax...
Function: ROUND

Function: ROUND

The ROUND function allows you to manage the decimal portion of a numeric value. It rounds a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUND function and also throw in some tips and error handling methods.Supported...
Function: AVERAGE

Function: AVERAGE

The AVERAGE function can calculate the average (arithmetic mean) of the values in a range of cells. In this guide, we’re going to show you how to use the function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax...
Function: SUM

Function: SUM

The SUM function can sum up the values in a range of cells. In this guide, we’re going to show you how to use the SUM function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax SUM(number1,[number2],…)Argumentsnumber1The...
Function: TODAY

Function: TODAY

The TODAY function returns the serial number of the current date without the time information. The return value gets updated with every recalculation. In this guide, we’re going to show you how to use the TODAY function and also throw in some tips and error handling...
Function: NOW

Function: NOW

The NOW function returns the serial number of the current date and time. The return value gets updated with every recalculation. In this guide, we’re going to show you how to use the NOW function and also throw in some tips and error handling methods.Supported...
Function: N

Function: N

The N function is an information function that returns a value converted to a number. In this guide, we’re going to show you how to use the N function and also throw in some tips and error handling methods.Supported versionsAll versionsSyntax N(value)ArgumentsvalueThe...
Function: NOT

Function: NOT

The NOT function is a logical function that returns the opposite of its argument. In this guide, we’re going to show you how to use the NOT formula and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax...
Function: XOR

Function: XOR

The XOR function is a comparison function that returns a Boolean value after executing an Exclusive Or logic operation. It returns TRUE if specified arguments contain both TRUE and FALSE values. If all conditions are TRUE or all are FALSE, the return value is FALSE....