Excel Formulas

How to Use If Then Else Statement in Excel VBA (4 Examples)

In this tutorial, I am going to share with you 4 practical examples to use the If Then Else statement in Excel. You can easily apply these examples ...

How to Do Correlation and Regression Analysis in Excel (with Steps)

The image below depicts the complete output of linear regression analysis. Introduction to Correlation and Regression Correlation is an ...

How to Use ISBLANK Function for Conditional Formatting in Excel

In a large dataset with numerous entries, there may be many blank cells. You may need to identify those empty cells. We can use the ISBLANK function ...

How to Use DSUM Function with Dynamic Criteria in Excel

Excel’s DSUM function is used to extract and sum a set of data from a database. It computes the sum of a set of data that meets certain criteria. In ...

How to Use the MIN Function to Exclude Zero in Excel – 5 Easy Methods

To find the minimum value and exclude zeros in a dataset or an array, you can use the MIN function. This dataset includes Product ID, Product ...

How to Use ISERROR and VLOOKUP Functions in Excel

VLOOKUP is a built-in Excel function. If you give a specific value in the VLOOKUP function it finds the value in a column and returns the ...

How to Use IF & OR Functions with Text in Excel (3 Examples)

While working in Excel, sometimes we need to find exact and partial matches of a text. We can use the combination of the IF & OR functions to do ...

How to Find Minimum Value That Is Greater Than 0 in Excel

Finding the smallest value other than zero can be cumbersome if we consider a large dataset. However, we can use the LARGE, COUNTIF, SMALL, ...

How to Create Bill Payment Checklist in Excel (2 Smart Ways)

In our day-to-day life, we need to deal with various bills. To organize the bill payment, we can create a bill payment checklist. In this article, I ...

Min Max Inventory Calculation in Excel (with Easy Steps)

The fundamental goal of inventory control is to guarantee that sufficient items or resources are available to fulfill demand without generating ...

How to Use DMAX Function in Excel with Multiple Criteria

The DMAX function is used for finding the maximum value of a column or field under multiple criteria. In this article we will show you how you can ...

How to Use Combined MIN and IF Functions in Excel (2 Ways)

Here, we have the sales data of three different brands for two different products along the location of their stores. We will apply a single ...

Difference Between MAX and MIN Function in Excel

The MAX and MIN functions are very frequently used in Excel. These functions have a wide range of uses. In this article, we determine the difference ...

Excel IF Statement Between Two Numbers: 4 Ideal Examples

Method 1 - Use IF Statement Between Two Numbers in Excel 1.1. Use IF Statement Between Two Numbers Exclusively Declare the boundary numbers. ...

How to Do 2D Interpolation in Excel: 2 Suitable Ways

Method 1 - Perform Interpolation of Linear 2D Data in Excel 1.1 Apply Mathematical Equation for Linear Interpolation There is an established ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo