Excel Functions Archives

How to Calculate Log in Excel (6 Effective Methods)

Jun 8, 2022 Excel Formulas

A logarithm is a mathematical operation that determines how a particular number, referred to as the base, is increased with the aid of multiplying ...

FIND Function Not Working in Excel (4 Reasons with Solutions)

Jul 25, 2022 Excel Functions

In this tutorial, we will explain the reasons for the problem of why the FIND function in excel is not working. In Microsoft Excel, the FIND function ...

How to Perform VLOOKUP with Multiple Rows in Excel (5 Methods)

May 23, 2022 Excel Functions

While working with the Microsoft Excel dataset, sometimes we need to look up unique values from multiple rows. We can easily do that by applying the ...

How to Find Second Match with VLOOKUP in Excel (2 Simple Methods)

Jun 29, 2022 Excel Formulas

Finding specific cell values manually from a range in Excel datasheets is a really inconvenient process. This article will show you the simple ...

How to Apply VLOOKUP by Date in Excel

Jun 29, 2022 Excel Formulas

We use VLOOKUP by date to find dates in a data table. It is very useful to find the values corresponding to particular dates from a dataset. The ...

51 Mostly Used Math and Trig Functions in Excel

Sep 6, 2022 Excel Basics

The Math & Trig functions in Excel are very common in many mathematical calculations like- basic arithmetic, conditional sum & product, ...

44 Mathematical Functions in Excel (Download Free PDF)

Sep 6, 2022 Excel Basics

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

COUNTIF vs COUNTIFS in Excel (4 Examples)

May 22, 2022 Excel Functions

COUNTIF vs COUNTIFS is a key phrase to differentiate between two functions; the COUNTIF and COUNTIFS. The COUNTIF function is a Statistical function ...

How to Count Rows with Formula in Excel (5 Quick Methods)

May 22, 2022 Excel Basics

In this tutorial, I will explain some methods to count the number of rows using Excel Formula. Usually, we can get the row count by simply clicking ...

How to Use Excel ADDRESS Function (7 Examples)

Sep 18, 2022 Excel Functions

The ADDRESS function in MS Excel is under the Lookup and Reference functions category. We use the ADDRESS function to get the address of a cell (e.g. ...

How to Use MMULT Function in Excel (6 Examples)

Sep 6, 2022 Excel Functions

The MMULT function stands for “Matrix Multiplication”. It is a math and trigonometry function available in Microsoft Excel. The MMULT function ...

How to Use DCOUNT Function in Excel (5 Suitable Examples)

Jun 28, 2022 Excel Functions

The DCOUNT function is a built-in function in Excel that is categorized as a Database Function. The DCOUNT function of Microsoft Excel is one of the ...

How to Use SLN Function in Excel (3 Examples)

Jul 13, 2022 Excel Functions

The SLN function, an Excel Financial function, calculates the depreciation of an asset for one time period using the straight line method for ...

How to Use TRUNC Function in Excel (4 Examples)

Jun 19, 2022 Excel Functions

The TRUNC function in Excel truncates a number to a specified number of digits. It is under the category of Excel Math and Trigonometry function. The ...

How to Use DGET Function in Excel (4 Examples)

May 19, 2022 Excel Functions

For looking up values we often use the VLOOKUP or XLOOKUP functions but there are some limitations like we can’t look up a value based on multiple ...