Tag Archives: Formulas

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

No Thumbnail

Excel Formulas and Function, Finding Text Within Another Text, Find()

The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found. You can download the workbook related to this article here. Jump To: Syntax Example 1 Example 2 Syntax: =FIND(Text_to_Find, Text_to_Search_in, Starting_Index) Text_to_Find: The

No Thumbnail

Excel INDEX() Function

In this article I will explain the INDEX() function in Excel. Basically this function receives a range of cells, a row index and a column index as input. It returns the the value or reference of the cell at the specified row and column index.

No Thumbnail

Excel Change Formula Calculation to Manual

In this article I will explain how you can prevent Excel from automatically updating formulas. This is specially useful when working with large workbooks with a large amount of formulas. You can force excel to update the formulas only when specified. – Changing Formula Calculation to Manual:

No Thumbnail

Excel COUNT() Function

In this article I will explain the count function. The COUNT() function returns the number of cells in a range which have numeric values in them. You can download the workbook for this article here. Jump To: Syntex Example 1, Get Row Count Example 2,

No Thumbnail

Excel Functions and Formulas, TEXT()

The TEXT() function converts a number value to a text string, with the format specified Jump To: Syntax Example 1, Converting Numeric Value to a Text String Using Currency Formatting Example 2, Adding Converted Value to a Text String Example 3, Converting Numeric Value to

No Thumbnail

Excel Functions and Formulas, IF()

In this article I will explain the IF() function. The IF() function receives 3 input parameters. The first input parameter is a logical test. The logical test will either equate to True or False. If the logical test equates to TRUE then the second parameter