Excel Formulas Archives

[Fixed!] Excel MOD Function Not Working (3 Issues with Solutions)

Dec 6, 2022 Excel Formulas

Sometimes you may need to use the MOD function in Excel. Eventually, the MOD function may not be working in Excel. In that case, if you are looking ...

How to Convert Complex Numbers to Polar Form in Excel

Dec 6, 2022 Excel Formulas

This article will illustrate how to deal with the Polar form of complex numbers in Excel. Download Practice Workbook You can download the ...

How to Create Permutation Table in Excel (4 Easy Methods)

Dec 6, 2022 Excel Formulas

This tutorial will demonstrate how to determine Excel permutation table. We use the Permutation in Excel where in the data the order of the data ...

How to Calculate Double Declining Depreciation in Excel

Dec 7, 2022 Excel Formulas

In this article, we will discuss the calculation process of Double Declining Depreciation in Excel. The Double Declining Depreciation is one of the ...

How to Get Remainder in Excel (3 Simple Methods)

Dec 5, 2022 Excel Formulas

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, ...

How to Insert Lowercase Delta Symbol in Excel (5 Easy Methods)

Dec 5, 2022 Excel Formulas

Delta is a Greek symbol widely used in scientific formulas and for other purposes. There are two types of delta symbols. One is uppercase(Δ) and the ...

How to Calculate Permutations Without Repetition in Excel

Dec 5, 2022 Excel Formulas

Permutation is such a great mathematical concept that has a significant impact on every aspect of education. We can see its usage in math, quantum ...

How to Calculate Delta Percentage in Excel (4 Easy Methods)

Dec 5, 2022 Excel Formulas

In this article, I will show how to calculate delta percentage in Excel. In many situations, we not only need the absolute change of a value but also ...

How to Calculate Delta Delta CT in Excel (With Easy Steps)

Dec 5, 2022 Excel Formulas

In this article, I will show how to calculate delta delta CT (Cycle Threshold) in Excel by using 4 easy steps. When you work on an Excel worksheet, ...

How to Truncate Decimal in Excel (6 Easy Ways)

Dec 5, 2022 Excel Formulas

We often use decimal values in Excel. For practical purposes, we need to modify these decimal values. And Excel can do this modification very ...

How to Truncate Text from Left in Excel (5 Suitable Ways)

Dec 5, 2022 Excel Formulas

When you have a big dataset with text as cell values, then you may need to shorten the text in Excel. Basically, you can truncate a text either from ...

How to Calculate Delta E Color in Excel (4 Suitable Methods)

Dec 5, 2022 Excel Formulas

If you want to find out the color difference between two samples, then you should calculate Delta E Color in Excel. So, if you are looking for how to ...

How to Truncate Date in Excel (4 Simple Methods)

Dec 6, 2022 Excel Formulas

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, ...

How to Create Payroll Calculator in Excel (with Easy Steps)

Dec 4, 2022 Excel Formulas

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Excel provides ...

How to Sum All Possible Combinations in Excel

Dec 5, 2022 Excel Formulas

Excel is a handy tool to carry out different calculations. It's often used for summation. This article is about how you can sum all possible ...