Calculate the Average Percentage in Excel
If you have a list of percentage values and you want to get the average percentage of them, you can do it in…
Category: formulas
Add or Subtract Multiple Cells in Excel
Excel usually allows you to do different calculations in a few different ways. It’s also the case if you want to do simple…
Range Based on Cell Value in Excel
Calculating ranges is easy. But have you ever tried to calculate a range based on the number in a specific cell? In this…
Excel if Cells Contain Specific Text
To check whether a cell contains specific text, you can use the SEARCH function. This function will return the position of the first…
Check if a Date is Between Two Dates in Excel
If you want to check whether the particular date is between two other dates, you can easily do it in Excel. In the…
VLOOKUP from Another Sheet
Using VLOOKUP between two worksheets is very similar to using VLOOKUP on the same worksheet. We are going to use two sheets (Sheet1…
Sheet Formula in Excel
SHEET and SHEETS are two new functions that appeared in Excel 2013 and are also present in Excel 2019 and Excel 365. The…
Check if a Value Is Between Two Numbers in Excel
You can use the IF function to check if a value is between two values. You can also combine IF and AND functions…
Sum Values Between Two Dates in Excel
Let’s say there is a list of dates and a list of values. You can easily sum them up with the SUM function….
Show Formulas in Excel
Normally, Excel displays the result of formula calculations. In this lesson, You will find a few ways how you can display formulas in…