by Ilker | Apr 17, 2019 | Excel Formulas
The Excel LEN function is a Text formula that returns the number of characters in a given string. In this guide, we’re going to show you how to use the Excel LEN function and also go over some tips and error handling methods. Supported versionsAll Excel versionsExcel...
by Ilker | Apr 15, 2019 | Excel Formulas, Excel Tips & Tricks
How to generate random numbers in ExcelYou can generate decimals between 0 and 1, and integers between certain limits using the RAND and RANDBETWEEN functions. RANDARRAY function is a new addition to randomization formulas, which is currently only available to a...
by Ilker | Apr 10, 2019 | Excel Formulas
The Excel CODE function is a Text formula that converts a specified character into the corresponding code based on the character set used by your computer. This can be useful for when you want to find out the code for a specific character, or using this value in other...
by Ilker | Apr 5, 2019 | Excel Formulas
The IFNA Excel formula is a Logical function that checks whether the reference contains an #N/A (not applicable) error. If the value is an #N/A error, the function returns a specified value; otherwise returns the value itself. In this guide, we’re going to show you...
by Ilker | Apr 4, 2019 | Excel Formulas
ISNA Excel function is an Information formula that checks whether the specified value is an #N/A (not applicable) error. The function returns a Boolean value – TRUE if there is an #N/A error, and FALSE if not. In this guide, we’re going to show you how to use...
by Ilker | Apr 3, 2019 | Uncategorized
One of the most common error codes, the #N/A error, stands for “not available” or “no value available”. This typically means that one or more references targeted by that cell is not valid or no result could be generated from your selection....
by Ilker | Apr 1, 2019 | Excel Formulas
The ISFORMULA is a Lookup & Reference function that checks whether the specified reference contains a formula. The function returns a Boolean value based on the outcome – TRUE if there is a formula, and FALSE if not. In this guide, we’re going to show you...
by Ilker | Mar 29, 2019 | Excel Formulas
The FORMULATEXT function returns the formula of a specified reference as a string. In this guide, we’re going to show you how to use FORMULATEXT function and also go over some tips and error handling methods. Supported versionsExcel 2013 and laterFORMULATEXT Syntax...
by Ilker | Mar 29, 2019 | Excel Formulas
The PRODUCT function is a Math & Trig formula that returns the product of all numbers entered as its arguments. In this guide, we’re going to show you how to use PRODUCT function and also go over some tips and error handling methods. Supported versionsAll Excel...