Excel Tutorial: IF Function

How to create a formula to check whether a number is within the range and how to grade it into categories?

You may use IF function in the data. The If function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

The syntax for the If function is:

If( condition, value_if_true, value_if_false )

  • condition is the value that you want to test.
  • value_if_true is the value that is returned if condition evaluates to TRUE.
  • value_if_false is the value that is return if condition evaluates to FALSE.

Let’s take a look at an example: Continue reading

Excel: How to combine or join text into one cell?

My friend asked me a question on how to merge First Name and Last Name into a single column in Excel instead of copy and paste the content from Column A and Column B to Column C 1 by 1. To solve his problem, they is a simple way to do that by using Concatenate function in Excel.

In Excel, the Concatenate function allows you to join character strings from several cells together in another destination cell.

The syntax for the Concatenate function is:

Concatenate( text1, text2, … text_n )

n = Up to 255 text entries can be added and entry must be separated by a comma. Continue reading