Excel Formulas Archives - Page 2 of 180

Excel Formulas

How to Concatenate with Delimiter in Excel (5 Easy Ways)

Dec 5, 2022 Excel Formulas

Excel concatenation is a useful and frequently used feature. If you want to join or delimit text, this article might be useful to you. In this ...

How to Calculate Factorial of Large Number in Excel

Dec 4, 2022 Excel Formulas

We frequently need to carry out some challenging mathematical computations while using Excel. The majority of these intricate mathematical ...

How to Truncate Text After Character in Excel (4 Suitable Ways)

Dec 6, 2022 Excel Formulas

In this article, we will learn how to truncate text after a character in Excel. Sometimes we need to truncate any cell information dependent on ...

How to Get Remainder in Decimal in Excel (3 Suitable Ways)

Dec 4, 2022 Excel Formulas

Excel can be very helpful in determining remainders. One might need these remainders in Integer or in decimal format. In this article, we will show ...

How to Calculate Option Greek Delta in Excel (with Easy Steps)

Dec 5, 2022 Excel Formulas

The Option Greek Delta calculates the rate of change in option prices in relation to the value of the underlying assets. The Greeks are more ...

How to Count Months from Date to Today by Using Excel Formula

Dec 4, 2022 Excel Formulas

Counting the number of months in Excel is a significant task in our day-to-day activities. It's necessary to count the months when keeping track of ...

How to Calculate Delta in Excel (2 Ideal Examples)

Dec 5, 2022 Excel Formulas

In this article, we will learn how to calculate delta in Excel. Delta indicates the difference between the 2 numbers. We can easily calculate delta ...

How to Divide Without Remainder in Excel (3 Effective Methods)

Dec 1, 2022 Excel Formulas

Division is a very important mathematical operation. When a number (dividend) can’t be divided exactly by another number (divisor) then there remains ...

How to Truncate Numbers in Excel (8 Suitable Methods)

Dec 6, 2022 Excel Formulas

Truncating a number means decreasing the number of digits from the decimal section or from the right side of that number in mathematics. In Excel, ...

How to Find Combinations Without Repetition in Excel

Dec 4, 2022 Excel Formulas

Combinations in mathematics is a concept that is quite important in various areas of mathematics, particularly in probability and statistics. It is a ...

How to Create All Combinations of 6 Columns in Excel (2 Methods)

Nov 29, 2022 Excel Formulas 3

While dealing with an Excel worksheet, you may need to generate all the combinations of a certain number of columns. Finding these combinations ...

Units of Production Depreciation Method with Formula in Excel

Dec 1, 2022 Excel Formulas

There are many ways of calculating Depreciation. Units of Production is one of them. The main objective of this article is to explain how to ...

How to Truncate Text in Excel (6 Suitable Methods)

Dec 6, 2022 Excel Formulas

When you have a big dataset with text as a cell value, then you may need to truncate text in Excel. So, if you are looking for how to truncate text ...

How to Stop Excel from Truncating Text (3 Easy Methods)

Dec 6, 2022 Excel Formulas

While working in Microsoft Excel, often users have to input long texts in a cell. By default, Excel hides these long texts after a certain limit or ...

How to Count Cells with Specific Value in Excel (5 Easy Methods)

Nov 30, 2022 Excel Formulas

While working in Microsoft Excel sometimes we need to count cells with specific value so that we can work more effectively. But it might seem ...