Tag Archives: Formulas

Use Any Formula: Worksheetfunction in VBA

Formulas in EXCEL Microsoft Excel offers several built-in functions that can be used as formulas in Excel worksheets. It displays the categories of functions available in the Insert Function window, as seen in the image below: Usage of Formula in an Excel Sheet Just like

How to Use Application.Calculation in VBA

The benefits of using Excel for calculation We are well aware that in today’s world, a machine’s brain works orders of magnitude faster than a human’s brain. By this, I mean that when there is a requirement to calculate some numbers mathematically, we have quickly

How Do You UNSORT Data in Excel?

The sorting feature of Excel is very useful to organize and put data into a structured format. But many times, we think of a better way to do it — only after we complete the data sorting! So somehow we have to revert the sorting

Cross Products with Excel and VBA

Microsoft Excel does not have the built-in worksheet functions to calculate the cross product of two vectors. Therefore, some techniques are required to do the calculation — either by setting up your own formula in a worksheet or by creating a custom VBA function. The

Using VBA Sum and VBA Sum Range

The Sum function in Excel is one of the most widely used functions, and in fact, probably one of the first functions that an Excel user learns when they are learning to use Excel!  Simply stated, the Sum function adds up a range of cells for

No Thumbnail

Excel Functions and Formulas, CHAR()

Each character is mapped to a numeric value. For example the character “A” is mapped to the number 65. The character “B” is mapped to the number 66 and so on. The CHAR() function receives an number as input and returns the character associated with that number. – Syntax:

No Thumbnail

Excel Functions and Formulas, INDIRECT()

The INDIRECT() function returns a reference specified by a text string. For example the formula below: =INDIRECT(“A1″) returns the value in cell “A1”. You can download the workbook related to this article here. Jump To: Syntax Example 1, Get Value From List, Based on Row Index Example