Category Archives for Formulas

Excel 3D Reference for Cells

 We all want to save our time. And, by using 3D Reference in Excel you can save your a lot of time. It’s is like three-dimensional chart or image which has more than one phase. A normal range is all about a group of cells from a single worksheet. For Example, in =SUM(Sheet1!A1:A10), “A1:A10” is a group of cells […]

SUMPRODUCT IF to Create a Conditional Formula in Excel

SUMPRODUCT is one of the most important Excel functions and the best part about it is, you can modify it in several ways.And, one of its powers which I have discovered recently is using it as “SUMPRODUCT IF”.In short, a Conditional SUMPRODUCT.As you know, you can use SUMPRODUCT to multiply and sum specified ranges or […]

How To Perform Two Way Lookup In Excel

 It happens sometimes when we need to lookup for a value from a table according to the row heading and column heading.Let say, if you need to get the values from above table for a particular month and zone.  Here in this situation you can use a two way lookup. Performing a two-way lookup is all about […]

How to use MAX IF Formula in Excel + [Multiple Criteria]

In Excel, we can’t simply use default MAX function with a condition (unless you are using Microsoft Office 365). If you ever try to get maximum value from a range using a specific condition you must need a MAX IF formula. Well, you can combine MAX and IF to create a formula which can help you to […]

How to Calculate Compound Interest in Excel

 Compound interest is one of the most important financial calculations which most of us often do in our work. And, it’s must to learn to calculate it in Excel. But, before you do that you need to understand what actually compound interest is. Investopedia says:Compound interest is interest calculated on the initial principal and also on the accumulated […]