by Ilker | Jan 9, 2019 | Excel Formulas
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...
by Ilker | Jan 9, 2019 | Excel Formulas
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...
by Ilker | Jan 9, 2019 | Excel Formulas
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...
by Ilker | Jan 9, 2019 | Excel Formulas
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...
by Ilker | Jan 9, 2019 | Excel Tips & Tricks
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...
by Ilker | Jan 8, 2019 | Excel Formulas
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...
by Ilker | Jan 8, 2019 | Excel Tips & Tricks
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...
by Ilker | Dec 26, 2018 | Excel Formulas
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)...
by Ilker | Dec 26, 2018 | Excel Formulas
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....