Excel IF Statement – How to Use

IF statement is undoubtedly one of the most important formulas in excel. In general, the IF statement gives the desired intelligence to a program so that it can make decisions based on given criteria and, most importantly, decide the program flow.In Microsoft Excel terminology, IF statement is also called as "Excel IF-Then statement" or "Excel … [Read more...]

Round Function In Excel – The Complete Guide

Microsoft Excel provides multiple formulas to round numbers. We have formulas like - ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD, and they all can be used to round numbers in excel.Rounding is the process of removing the least significant digits from a number so that we are left with a simpler value that is … [Read more...]

VBA Wait and Sleep Functions – Explained

Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. These methods suspend all the activities of Microsoft Excel and sometimes may also prevent you from performing other operations on it until the pause is in effect.However, your computer can simultaneously process other background … [Read more...]

Excel SUMIF and SUMIFS – Explained

As the name suggests SUMIF and SUMIFS formulae are formed by combining SUM and IF functions. In simple English, this implies that these functions can add items or cells that fulfill a particular criterion. Let’s understand it in detail.Understanding SUMIF and SUMIFS FunctionsYou know SUM function has the capability to add items, and SUMIF … [Read more...]

VBA Substring – How to Substring in Excel Macro

Substring is one of the most popular functions in any programming language. It eases your tasks while dealing with strings. As the name suggests a substring function divides a string into different parts based on particular criteria.There are multiple VBA Substring functions. In practical situations, these substring functions can be quite … [Read more...]

HLOOKUP in Excel – With Examples

HLOOKUP function in Excel is a sibling of the VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called Horizontal Lookup.HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular.The task of the … [Read more...]

VBA On Error Statement – Handling Errors in Excel Macros

While writing Excel Macros we generally put more focus on the coding part and getting the desired result but during this process, we forget an important thing i.e. Error handling. Error handling is an important part of every code and VBA On Error Statement is an easy way for handling unexpected exceptions in Excel Macros.A well-written macro is … [Read more...]

VLOOKUP In VBA – With Examples

In my earlier post, I had written about VLOOKUP in Excel. It was a massive post of around 2500 words, it explains most of the things about the vertical lookup function in excel. Today’s post is an extension to that post and here we will understand how to apply a VLOOKUP in VBA.If you haven’t read that post then I would strongly recommend you … [Read more...]

Privacy Policy | Disclaimer | About