Tag Archive for ‘Formulas’

Case-Insensitive Match

Excel Exact Formula is Case-Sensitive. Learn how to do Case-Insensitive Match. Exact Function is one of the Case-Sensitive Formulas in Excel. In this Post we will see how we can do case-Insensitive match between two text strings. Case-Insensitive Match is… Read More ›

Excel Mid Formula

Learn How to use Excel Mid Formula: As name depicts, Mid Function is used to extract the characters from middle of the formula. Excel Mid Formula extracts the specified number of characters from specified position. Mid Function Syntax: Mid(text, start_num,… Read More ›

Excel Left Formula

Learn How to use Excel Left Formula: Excel Left Formula extracts the specified number of characters from the left hand side of a cell. It is used to remove unwanted characters from Right Side of a cell. Left Function Syntax:… Read More ›

Excel Right Formula

Learn How to use Excel Right Formula: Excel Right Formula extracts the specified number of characters from right hand side of a cell. In other words, it extract data from the the end of a text string. It is used… Read More ›

Excel Exact Formula

Learn How to use Excel Exact Formula: Excel Exact Formula compare two cells and returns True if they match, otherwise it returns False. Importantly, Exact Function is Case-Sensitive. However, it doesn’t consider the formatting differences. Exact Function works with Text… Read More ›

Excel Hlookup Formula

Learn How to use Excel Hlookup Formula: In Excel HLOOKUP formula, H stands for Horizontal and LOOKUP means lookup. Hlookup is used to lookup values in a data table where lookup_value resides. Lets see Hlookup syntax and an example to… Read More ›

Excel Vlookup Formula

Learn How to use Excel Vlookup Formula: In Excel VLOOKUP formula, V stands for Vertical and LOOKUP means lookup. Vlookup is used to lookup values in a data table where lookup_value resides. Lets see Vlookup syntax and an example to… Read More ›

Excel Averageifs Formula

Learn how to use Excel Averageifs Formulas: Excel Averageifs Formula averages a Set of values IF(S) a single or multiple conditions are met. In other words, averageifs function averages the number of cells that met one or more than one… Read More ›

Excel Averageif Formula

Learn how to use Excel Averageif Formula: Excel Averageif Formula AVERAGE the data value IF it meets specified criteria or condition. Lets understand this with the help of Averageif Formula syntax and an example. Averageif Function Syntax: Averageif(range, criteria, [average_range])… Read More ›