The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.
IF(logical_test, [value_if_true], [value_if_false])
Example:
Showing posts with label MS Excel. Show all posts
Showing posts with label MS Excel. Show all posts
Thursday, December 13, 2012
If function Excel
Excel > Functions > IF
The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.
The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.
Wednesday, August 1, 2012
MS Excel: Concatenate strings
Excel > Operators> Concatenate
To concatenate multiple strings into a single string in Excel, you can use the "&" operator to separate the string values.
To concatenate multiple strings into a single string in Excel, you can use the "&" operator to separate the string values.
string_1 & string_2 & string_n
Subscribe to:
Posts (Atom)