CELL Formula in Excel - How to Use CELL Formula and Examples

Posted on 14 November 2009

Syntax of CELL Formula Example of CELL Formula Possible Errors returned by the CELL Formula CELL formula returns infomation about the various attributes of a cell such as address, color, width, column / row postitions etc. CELL Formula Syntax in Excel The CELL Formula has two parts: CELL (attribute_type, cell_reference) attribute_type attribute_type specifies the attribute that you are trying to find. It can be color, column / row position, width, ... Continue Reading

Comments (1)

INDEX Formula Excel - How to use Excel INDEX Function

Posted on 26 August 2009

Syntax of INDEX Formula Example of INDEX Formula Possible Errors returned by the INDEX Formula INDEX formula in Excel returns the cell at the intersection of a particular row and column within a range. The INDEX formula is typically used to locate a value in a given range by specifying its X-Y coordinates (i.e. the row and the column) within the range. INDEX Formula Syntax INDEX Formula has four parts: INDEX (range_to_search_in, row_position, column_position, range_number) ... Continue Reading

Comments     

DATE Formula Excel - How to use Excel DATE Function

Posted on 23 July 2009

Syntax of DATE Formula Example of DATE Formula Possible Errors returned by the DATE Formula DATE formula in Excel returns the number representing the date for a given day, month and year. The DATE formula is typically used to construct a date by providing the constituting parts such as day, month and year. The minimum and maximum values that a date can take is Office 2003 is January 1, 1900 and December 31, 9999 (if that existed). DATE Formula ... Continue Reading

Comments (18)

MATCH Formula Excel - How to use Excel MATCH Function

Posted on 13 July 2009

Syntax of MATCH Formula Example of MATCH Formula Possible Errors returned by the MATCH Formula MATCH formula in Excel returns the relative position of a value in an array or a range MATCH Formula Syntax MATCH Formula has three parts: MATCH (value_to_find, range_to_find_value_in, match_type) value_to_find value_to_find is the value which we are trying to find. It can be a number or a string. If the value_to_find is specified as a ... Continue Reading

Comments (2)

ADDRESS Formula Excel - How to use Excel ADDRESS Function

Posted on 10 July 2009

Syntax of ADDRESS Formula Example of ADDRESS Formula Possible Errors returned by the ADDRESS Formula ADDRESS formula in Excel generates the address for a cell when provided a row and a column number. ADDRESS Formula Syntax ADDRESS Formula has five parts: ADDRESS (row_num, col_num, ref_type, ref_style, sheet_name) row_num row_num is the row number in which the cell for which you are trying to generate the address is located. It is ... Continue Reading

Comments     

Array Formulas Examples

Posted on 08 July 2009

Array formulas help you turn normal Excel Formulas into super formulas. Here are a few examples of Array formulas. These examples highlight the use of multiple conditions within a single array formula and how we can club multiple formulas in to a single array formula. Array formulas are powerful - no doubt about that. However before we go any further, one must look at the flip side to using array formulas. They take much more computational power and can slow ... Continue Reading

Comments