Excel Functions

How to Calculate Log in Excel (6 Effective Methods)

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)

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)

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)

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

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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 ...

ExcelDemy
Logo