Learn Microsoft Excel Online FreeIF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like “abc”, you can build formula with IF function to return result. FORMULA To test if… read more »
AVERAGE function is one of the most popular functions in Excel. Apply AVERAGE together with some other functions, we can calculate average simply for some complex situations. In this article, we will introduce you to calculate average of the last N numbers from a range contains both numeric values and non-numeric values. EXAMPLE In this… read more »
This post will guide you how to count the number of cells that only contain numbers within a range of cells using a formula in Excel 2013/2016. Count Number of Cells that Contain Numbers Assuming that you have a data list in the range of cells B1:B6, and you want count the number of cells… read more »
This post will guide you how to count the number of cells that contain X or Y in a given range cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells contain… read more »
This post will guide you how to get initials from a given name using a formula in Excel. How do I extract initials from names in Excel 2013/2016. Extract Initials from a Name Using a Formula Extract Initials from a Name Using User Defined Function Assuming that you have a list of data in range… read more »
This post will guide you how to extract number from a given test string in Excel. How do I extract all numbers from string using a formula in Excel. How to get all number from a given test string using user defined function in Excel. Extract Number from String with Formula Extract Number from String… read more »
This post will guide you how to filter values starts with number or letter in one single cell in Excel. How do I filter in a list those that begin with number or letter using a formula in Excel. Filter Cells Starts with Number or Letter Assuming that you have a list of data in… read more »
This post will guide you how to ignore error values when getting average for a range of cells in Excel. How do I average a range of cells ignoring error values, such as: #div/0!. Assuming that you have a list of range of cells that you want to calculate the average of those cells which… read more »
This post will guide you how to limit cell entries to specific length and number of digits in Excel. How do I limit data entry to allow only text or only numbers entered into in a cell using Data Validation option in Excel. How to limit entries to numeric values in Excel. Limit Data Entry… read more »
This post will guide you how to ignore blank cells in a formula in Excel. How do I ignore blank cells when performing calculations in a formula in Excel. Ignore Blank Cells in a Formula Video：Ignore Blank Cells in a Formula Ignore Blank Cells in a Formula If you have a formula to calculate a… read more »
This post will guide you how to return a value if a cell contains a certain number or text string in Excel. How do I check if a Cell contains specific text and then return another specific text in another cell with a formula in Excel. Return Value If Cell Contains Certain Value Video: Return… read more »
This post will guide you how to sort cells or text values in a column based on a specific word even if the word is in the text string in the cell. How do I sort cells in a column by the number of a specific word or words in excel. Sort Cells by Specific… read more »
This post will discuss that how to count the number of cells that contain specific text or certain text in a specified cells of range in Excel. How to get the total number of cells that contain certain text. Count Cells That Contain Specific Text Assuming that you have a data of list in range… read more »
This post explains that how to get the first match that cell contains one of several values from another range or a list in excel. before we talked the way that how to check a cell to see that if it contains one of several values in a range or list using the SEARCH function… read more »
In the previous post, we talked that how to check if cell contains all of values from a list in excel, and this post will guide you how to test a cell if it contains one of several values in a range or a list in excel. How to check that at least one value… read more »
This post explains that how to check if a cell contains all of several values from a range in excel. How to check if cell contains all of many values in a list in excel 2013. How to check if all of values in a list can be found in a cell, if TRUE, then… read more »
If you want to check if the values that contain a specified text string in one cell, you can use a combination of the FIND function and ISNUMBER function as a formula in the Data Validation. Data Validation for Specified Text only Suppose that you want to check that if the values in column B… read more »
This post will guide you how to use ISNUMBER function with syntax and examples in Microsoft excel. Description The Excel ISNUMBER function returns TRUE if the value in a cell is a numeric value, otherwise it will return FALSE. so you can use ISNUMBER function to check if a cell contains a numeric value or check the… read more »
Normally, If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”. Excel IF function check if a cell contains text(case-insensitive) By default, IF function is case-insensitive in excel. It means that the logical text for text values… read more »
