

Category Archives for "Formula Hacks"

0 Test Multiple Conditions Using Excel IFS Function

Excel 2016 came with a new function – the IFS function. You can use this function to test multiple conditions at once and then return the result based on it. This is helpful as you don’t have to create those long nested IF formulas that used to get confusing. Note that the IFS function is […]

5 Get Only the Numeric or the Text Part from a String Using Excel Formulas

Dataset to get the numeric or the text part in Excel

There is no inbuilt function in Excel to remove all the text part from a string and get only the numeric part (or vice versa – remove the numeric part and give only the text part from a string in a cell). However, this can be done using a cocktail of Excel functions. Let me show […]

5 Lookup the Second, the Third, or the Nth Value in Excel

Formula to lookup the second third and nth value

Watch Video – Lookup the Second, the Third or the Nth Matching Value When it comes to looking up data in Excel, there are two amazing functions that I often use – VLOOKUP and INDEX (mostly in conjunction with the MATCH function). However, these formulas are designed to find only the first instance of the lookup […]

10 Use IFERROR with VLOOKUP to Get Rid of #N/A Errors

Error with VLOOKUP when lookup value not found

When using the VLOOKUP formula in Excel, sometimes you may end up with the ugly #N/A error. This happens when your formula can not find the lookup value. In this tutorial, I will show you different ways to use IFERROR with VLOOKUP to handle these #N/A errors cropping up in your worksheet. Using the combination […]

4 Using Excel PMT function to Calculate Loan Payment Amount

Excel PMT Function - home loan payment calculation

Excel PMT function is one of the many financial functions available in Excel. It helps you calculate the payment you need to make for a loan when you know the total loan amount, interest rate, and the number of constant payments. For example, suppose you buy a house for USD 200,000. Since you don’t have that […]

12 How to Calculate the Number of Days Between Two Dates in Excel

Calculate the Number of Days Between Two Dates in Excel - networkdays result

Excel has some powerful functions to calculate the number of days between two dates in Excel. These are especially useful when you’re creating Gantt charts or timelines for a proposal/project. In this tutorial, you’ll learn how to calculate the number of: Days between two dates. Working days between two dates. Weekends between two dates. Working […]

17 How to Quickly Insert Date and Timestamp in Excel

A timestamp is something you use when you want to track activities. For example, you may want to track activities such as when was a particular expense incurred, what time did the sale invoice was created, when was the data entry done in a cell, when was the report last updated, etc. Let’s get started. […]

1 2 3 … 7 Next »