Excel Formulas

### Mortgage Payoff Calculator with Extra Payment (Free Excel Template)

Mortgage Payment Calculator with Extra Payment "No Macro used. No installation is necessary. Just download and start using." - ...

### How to calculate weighted average in Excel with percentages (2 ways)

In this article, I will show you how to calculate the weighted average formula in Excel with percentages. The weighted average is the average where ...

### Calculate Excel percentage difference between two numbers (using formula)

In this article, we will see the formula to calculate the percentage difference between two Numbers in Excel. There is basically one formula to ...

### Excel Formula to Calculate Hours Worked Minus Lunch

In this article, I will show you the Excel formula to calculate hours worked minus lunch. The lunchtime can be in hours or it can be expressed as in ...

### How to calculate periodic interest rate in Excel (4 ways)

In this short article, I will show how to calculate periodic interest rates in Excel. I will show 4 methods of calculating the periodic ...

### How to calculate years of service in Excel (3 easy ways)

Suppose you have an employee name who recently resigned from your company. You want to calculate his/her years of services at your company. There are ...

### How to Sum Multiple Rows and Columns in Excel

Summing up multiple rows and column in Excel is important for many purposes. In this article, we will see different techniques on how to sum / ...

### Using Excel to Round to Nearest 1000 (7 Easy Ways)

Sometimes it is often required to round numbers to its nearest hundreds or thousands. In this article, we will see how Excel round to nearest 1000. ...

### How to calculate working days in Excel excluding weekends & holidays

It is often required in Excel to find out the total number of working days between two dates. Usually while counting this, we often neglect the ...

### Count Cells that Contain Specific Text in Excel

While working with a big range of data it is often required to find the number of specific text. In this article, we will count cells that contain ...

### VLOOKUP and HLOOKUP combined Excel formula (with example)

In this article, we will see how to use VLOOKUP and HLOOKUP Combined functions together in Excel formulas. Here we will use VLOOKUP and HLOOKUP ...

### How to calculate IRR (internal rate of return) in Excel (9 easy ways)

In this article, I will discuss how to calculate/find IRR (internal rate of return) in Excel. I will focus on several topics like: Calculating ...

### Excel Data Validation Based on Another Cell Value

Data Validation is an important feature in Excel. In this article, we will see how Excel data validation based on another cell is created. Data ...

### How to calculate monthly payment in Excel (with Excel calculator)

In this article, I will show you how to calculate monthly payments in Excel with some examples and criteria. Here are the criteria: You ...

### INDIRECT Function Excel: Get values from different sheet

While working in Excel, there are many cases where you want to refer your worksheet to a different worksheet. The topic that we will be discussing in ...