Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Reference

TRANSPOSE

  • May 31, 2023
Definition: The TRANSPOSE function in Excel is used to transpose a range of cells. Syntax: ==TRANSPOSE(array). Situation: This formula is appropriate in situations where you need to transpose...
Read More

OFFSET

  • May 31, 2023
Definition: OFFSET is a function that returns a reference to a range that is offset from a starting cell reference. Syntax: =OFFSET(reference, rows, cols, [height], [width]) Situation: This...
Read More

INDIRECT

  • May 31, 2023
Definition: INDIRECT is a function that returns a reference to a range based on a text string. Syntax: =INDIRECT(ref_text, [a1]) Situation: This formula is suitable when you need...
Read More

CELL

  • May 31, 2023
Definition: CELL is a function that returns information about a cell, such as its format, contents, or location. Syntax: =CELL(info_type, [reference]) Situation: This formula is suitable when you...
Read More

COLUMN

  • May 31, 2023
Definition: COLUMN is a function that returns the column number of a cell reference. Syntax: =COLUMN(reference) Situation: This formula is suitable when you need to retrieve the column...
Read More

COLUMNS

  • May 31, 2023
Definition: COLUMNS is a function that returns the number of columns in an array. Syntax: =COLUMNS(array) Situation: This formula is suitable when you need to retrieve the number...
Read More

ADDRESS

  • May 31, 2023
Definition: ADDRESS is a function that returns a cell reference as a string, based on a specified row and column number. Syntax: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) Situation:...
Read More

AREAS

  • May 31, 2023
Definition: AREAS is a function that returns the number of areas in a reference. Syntax: =AREAS(reference) Situation: This formula is suitable when you need to count the number...
Read More