Search This Blog

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.
       IF(logical_test, [value_if_true], [value_if_false])
 
Example:







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.
string_1 & string_2 & string_n