Excel Formulas

How to Calculate Logarithmic Interpolation in Excel (2 Easy Ways)

Interpolation is the process of determining the value of an unknown point that lies between two known data points. While calculating linear ...

How to Convert Negative Value to Positive in Excel Using Formula

In this article, we will show how to convert negative value to positive in Excel using formula. We will create Excel formulas with common functions ...

How to Create Dynamic Range Using Excel INDEX Function

Creating a named range in Excel is an easy task. But, if you want to make the named range dynamic so that whenever you add new data, the named range ...

Check If a Cell Contains Text and Return the Value with Multiple Conditions in Excel – 7 Methods

Method 1 - Using the XLOOKUP Function to Check If a Cell Contains Text and Return the Value in Excel The sample dataset contains students' Names. ...

How to Use IF Statement Based on Cell Color in Excel

Download the Practice Workbook If Statement Based on Cell Color.xlsm 3 Uses of IF Statement Based on Cell Color in Excel ...

How to Calculate Commission in Excel Using IF Function

The Calculation of commission is one of the basic tasks of Excel applications for a long period of time. Calculating commission based on the sales ...

How to Calculate Partial Correlation in Excel (3 Suitable Ways)

Microsoft Excel is a powerful software. We use Excel functions and features for our educational, business, and other mathematical analyses such as ...

Dynamic Data Validation List in Excel with IF Statement Condition

In this article, you will learn about four easy methods for creating a dynamic data validation list in Excel using the IF statement condition. We ...

How to Use IF Statement with Not Equal To Operator in Excel

To illustrate using the IF function with the not equal to operator, let's examine a representative dataset. First Collection and Second Collection ...

How to Find Average with Blank Cells in Excel: 4 Easy Ways

Method 1 - Use AVERAGEIF Function to Find Average with Blank Cells in Excel Steps: Add a row named Average in row 11. Type the following ...

How to Use Dividend Discount Model Formula in Excel

The Dividend Discount Model Formula determines the stock price based on the probable dividends one will pay. It helps to evaluate a company based on ...

Excel DSUM vs SUMIF Functions (2 Suitable Examples)

We normally need to evaluate the summation of values by criteria. Which is one of the most commonly used functions in the world. So, to carry out ...

Excel Formula for Finding Odd or Even Numbers

In this article, we will show formula for finding odd or even numbers in Excel. We will create Excel formula with common functions like IF, MOD, ...

How to Pull Data from a Date Range in Excel: 7 Ways

We'll use a simple sales dataset to demonstrate how you can pull data from a date range. Method 1 - Using the FILTER Function Steps: ...

How to Find Difference Between Rows and Columns in Excel

In this article, we will show the difference between rows and columns in Excel in tabular format. Moreover, you will learn about two easy methods for ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo