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 | Jun 6, 2018 | Excel Tips & Tricks
The logical tests and conditional checks have important role in Excel models. Potential errors can be detected and handled by using the right logical tests. If you know How to check if a value exists in a list, you can use this logical statement to detect and...
by Ilker | May 31, 2018 | Excel Tips & Tricks
This article shows how to count values by length based on their character count. This method can be helpful to check your data against invalid entries. It is also a good practice to use SUMPRODUCT and N functions together. Syntax =SUMPRODUCT(N(LEN(range)>character...
by Ilker | Apr 12, 2018 | Excel Tips & Tricks
In complex models, it is important to write comments explaining how the formulas work. But the limitation of Excel’s Insert Comment feature is that you must type the entire comment in a textbox. There is an alternative. You can use N() formula to insert your...