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.

Excel Sumifs Formula

Learn how to use Excel Sumifs Formula: Excel Sumifs Formula sum a Set of values IF(S) a single or multiple conditions are met. In other words, sumifs function count number of cells that met one or more than one condition…. Read More ›

Excel Countifs Formula

Learn how to use Excel Countifs Formula: Excel Countifs Formula COUNT number of cells IF(S) a single or multiple conditions are met. In other words, Countifs Function count number of cells that meet one or more than one condition. Countifs… Read More ›

Excel Countif Formula

Learn how to use Excel Countif Formula: Excel COUNTIF Formula COUNT number of Cells IF a given criteria is meet. In other words, Countif Function count number of cells that have an item in a list. Make a note that… Read More ›

Excel Sumif Formula

Learn how to use Excel Sumif Formula: Excel Sumif Formula adds the data value that meets specified criteria or condition. Lets understand this with the help of Sumif Formula syntax and an example. Sumif Function Syntax: Sumif(range,criteria,[sum_range]) Range: The range… Read More ›

Excel Isnumber Formula

Learn how to use Excel Isnumber Formula: Excel Isnumber formula test if a cell has number or not. It returns True if the value in cell is number, otherwise False. For Example, 123 is a number and Isnumber Formula will… Read More ›

Excel Istext Formula

Learn how to use Excel Istext Formula: Excel Istext formula test if a cell has text or not. It returns True if the value in cell is Text, otherwise False. For Example, “ABC” is a text and Istext Formula will… Read More ›

Excel Small Formula

How to use Excel Small Formula: Excel Small Formula is used to find the nth Smallest number in a set of values. For Example: Small can be used to find the Lowest Marks scorer, second Lowest Marks scorer, third Lowest… Read More ›

Excel Large Formula

How to use Excel Large Formula: Excel Large Formula is used to find the nth largest number in a set of values. For Example: Large can be used to find the highest Marks scorer, second highest Marks scorer, third highest… Read More ›

Excel MIN Formula

How to use Excel MIN Formula: MIN stands for Minimum. Excel MIN Formula can be used to find the Lowest value from a set of values or a given list. For Example, it can be used to figure out as… Read More ›