Tag Archives: Formulas

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

No Thumbnail

Excel, Date() Function

The Date() function can be used to specify a date value in a cell. Jump To: Syntax Example 1 Example 2 Example 3 Example 4 You can download the file for this article here. – Syntax: =Date(Year, Month, Day) Year: The year value of the date

No Thumbnail

Excel Functions and Formulas, LEN()

The LEN() function returns the number of characters in a text string. Syntax: =LEN(Text String) Text String: The text string to return the number of characters of. – Example: Lets say we want to receive the number of characters of the text string in cell