Excels Case
Essay by Kill009 • March 11, 2012 • Study Guide • 617 Words (3 Pages) • 1,413 Views
1. VLOOKUP
Background: This formula looks for a value in the leftmost column of a table, and then returns a value in the same row from the column you specify.
Composition of the formula:
Lookup_value is the reference text, number or cell value one wants to look out for a specific range
Table_array is the range within which one wants to check for the Lookup_value
Col_index_num is the column number that you want to extract incase of Lookup_value match when your Table_array has multiple columns
Range_lookup is a logical value to check for the exact match when mentioned as 0 (Zero) or closest match when mentioned as 1 (One)
2. IF
Background: This formula checks whether a condition is met, and returns one value if True and another value if False.
Composition of the formula:
Logical_Test is the condition one wants to check
Value_if_true is the value one wants to display if the condition is met
Value_if_false is the value one wants to display if the condition is not met
3. COUNTIF
Background: Counts the number of cells within a range that meet the given condition
Composition of the formula:
Range is field wherein one mentions the column or area from where the counts are required
Criteria mentions the condition for the COUNTIF
4. CONCATENATE
Background: This function joins several text strings into one text string
Composition of the formula:
Text 1, Text 2 and so on- These fields specifies the cell references to be joined in the single cell
5. FIND
Background: Returns the starting position of one text string within another text string. Find is case sensitive
Composition of the formula:
Find_text is the text value or cell reference in case of range that one needs to find in the source cell
Within_text is the cell reference for the source cell within which one wants look out for the text or cell reference given in Find_text field
Start_num is the character number in the source cell from where one wants to start the search
6. TRIM
Background: Removes all the extra spaces from
...
...