Insert Symbols in Excel Using UNICHAR Function

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

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.  ...
How to Use ISNUMBER Function in Excel

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

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

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