# Excel Tutorial: How do I round up the number with multiple decimal point

In Excel, there are two method to round up the value into decimal point.

1st Method :

• Highlight the cell that you need to round up.
• Right click on the mouse and choose ‘Format Cells’.

# 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