Insert Symbols in Excel Using UNICHAR Function
The Excel UNICHAR function is a Text formula, designed to return the Unicode character corresponding to any specified numeric code. This function simplifies the process of incorporating unique symbols in Excel, especially those not readily available on a standard...
Excel NETWORKDAYS.INTL Function to Calculate Work Days
The NETWORKDAYS.INTL is a Date & Time function that calculates and returns the number of workdays between two given dates. The NETWORKDAYS.INTL function allows you to specify which days of the week are weekends and also use a list of holidays. In this guide, we’re...
How to Use LOOKUP Function in Excel with Formula Examples
The Excel LOOKUP is a Lookup & Reference formula that can search a value inside a column or row, and return a matching value from the same position in another column or row. In this guide, we’re going to show you how to use the Excel LOOKUP function and also go...
How to Use FORECAST Function in Excel with Formula Examples
The FORECAST function is a Statistical function that predicts a future value by using existing values along with a linear trend (linear regression). You can use the forecasting function to predict future sales, inventory requirements, or consumer trends. In this...
LEN Function to Count Characters in Excel
The Excel LEN function, also known as LENGTH 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. ...
Distinguish Between Odd and Even Numbers Using ISODD Function in Excel
The ISODD function in Excel is an Information formula that returns TRUE if the number argument is an odd number, or FALSE if it's even, thereby providing a simple yet effective way of distinguishing between odd and even numbers. You can test the result of a formula or...
How to Use ISNUMBER Function in Excel
The Excel ISNUMBER function is an Information formula that returns TRUE if value is a number, and FALSE if not. As the name suggests, the formula asks the question "Is number?" to its argument. This way, you can test the outcome of a formula or a cell value using this...
Count Non-blank Cells in Excel Using COUNTA Function
The Excel COUNTA function is a statistics formula that returns the number of cells in a range that are not empty. Unlike the COUNT function, which only counts cells containing numbers, COUNTA includes cells with any type of information in them, containing numbers,...
How to Use the ISNONTEXT Function in Microsoft Excel
Many times, while working with data in Excel, you may as well feel a need to find the cell which is not in a text format cell in excel. In that case, the ISNONTEXT function in Excel becomes useful, to find non-text cell in excel. This function serves a critical role...