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...
How to check if a value exists in a list

How to check if a value exists in a list

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...
How to count values by length

How to count values by length

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...
How to add comments into formulas

How to add comments into formulas

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...