Formulas rss

Learn MS Excel Formulas. It is very helpful for Basic to Advanced Users. Formulas has been explained with the help of Step by Step Tutorial. It includes example with each formula for better understanding of Excel Functions.

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 ›