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 versions All versions Syntax...
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 versions All versions Syntax SUM(number1,[number2],...) Arguments number1...
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...
How to add a custom button to Excel Ribbon

How to add a custom button to Excel Ribbon

Ability to add a custom button helps you quick access to your macros or favorite actions directly from the Ribbon. The Ribbon was introduced in 2007 and made customizable with Excel 2010. So you can use this trick in all versions starting with 2010. This article shows...
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 versions All versions Syntax N(value) Arguments...
What does double minus -- do in Excel

What does double minus -- do in Excel

The double minus, also known as double unary, is an operation to convert Boolean values into ones and zeroes. Simply; TRUE to one (1) and FALSE to zero (0). A unary operation is an operation with only one operand, which is in contrast to binary operations that use two...
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 versions All Excel versions Syntax NOT(logical)...
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....