Use SUMIF with Wildcard Characters in Excel
The SUMIF formula in Excel is simple to use. It is very intuitive for every user. It has three parameters: range, criteria, and…
Category: formulas
Calculate the Original Loan Amount in Excel
A loan has four main elements: the amount, the interest rate, the loan term or the number of periodic payments, and the payment…
Calculate Percentiles from Mean & Standard Deviation in Excel
Excel is one of the best tools devised for various calculations. Formulas in Excel are grouped into multiple subcategories: mathematical, financial, date &…
Round Value to the Nearest Quarter in Excel
Sometimes as we work with Excel we may need to round values to the nearest quarter. This tutorial shows you 4 methods of…
Match Date to a Range of Dates and Times in Excel
There are numerous tools at our disposal when it comes to extracting data. Excel is undoubtedly one of the best of them. If…
Transpose VLOOKUP in Excel
The VLOOKUP function looks for a value in the leftmost column of a table and then returns a value in the same row…
Empirical Probability in Excel
Probabilities of events are stated as numbers ranging from 0 to 1. The closer the probability of a given event is to 1,…
Get Cell Value From Address in Excel
When working with Excel, in certain instances, you would like to know the value of your cell based on its location. To do…
Convert Month Number to Month Name in Excel
In Excel, there are solutions for every problem that we have. This refers to both mathematical, logical, and graphical issues, as well. It…
Sum Only If Value in Excel Cell Is Number and Not Text
Sometimes we have a dataset that contains both numeric and text values in a column. We may want to sum only the numeric…
