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....
Function: OR

Function: OR

The Excel OR function is a comparison function that returns TRUE if at least one of the specified conditions is TRUE. If no condition is met (FALSE), the return value is FALSE. In this guide, we’re going to show you how to use the Excel OR function and also go over...
Function: AND

Function: AND

Excel AND function is a logic comparison function that returns TRUE, if all specified conditions are met, and FALSE, if they’re not. It In this guide, we’re going to show you how to use Excel AND function and also go over some tips and error handling methods....
How to hide named ranges using VBA

How to hide named ranges using VBA

You might want to hide the named ranges in your workbook to prevent your users to tamper with your calculations. In this article, we’re going to show you how to hide named ranges in Excel using VBA.   How to hide named ranges using VBA Named ranges are objects...