# How to make a function retain two decimal places without change

### excel function calculation how to retain 2 decimal places a?

excel function calculation to retain 2 decimal places of the specific steps are as follows:

Method 1

Select the data format to change the data column, and then right-click. Select the “Set Cell Format” option.

2. In the pop-up dialog box, select “Numbers”, click “Numeric”, in the number of decimal places, enter 2. Click OK option. You can get the data to retain two decimal places

Method two

1. There is a simpler way to change the data format of the selected data columns, in the data table at the top of the “Start” option of the “Numeric “plate in the “Start” option at the top of the data table in the “Numbers” section there are two buttons as shown in the figure.

2. Click the left button you can move the decimal point to the left one, click the right button you can move the decimal point to the right one, and so on to get the desired data format.

Expanded information:

MicrosoftExcel is a spreadsheet program written by Microsoft for computers using the Windows and AppleMacintosh operating systems. An intuitive interface, excellent calculation features and charting tools, combined with successful marketing, have made Excel the most popular personal computer data processing software. In 1993, after the release of version 5.0 as a component of Microsoft Office, Excel began to become the dominant spreadsheet software on the applicable operating platform.

### What are the functions that preserve two decimal places?

=ROUND(A1,2).

The ROUND function in the above formula will be the data in A1 rounded to retain two decimal places.

The A1 value of 8.888 as an example, EXCEL can calculate the cell and retain two decimal functions are as follows:

① = ROUND (A1,2) = 8.89 analogous = ROUNDUP (A1,2).

The zhuanROUND function in the above formula will be rounded up to two decimal places in A1.

② = TRUNC (A1,2) = 8.88 similar to = ROUNDDOWN (A1,2).

The TRUNC function in the above formula will truncate the data in A1 to take the value of two decimal places.

③ = TEXT (A1, “0.00”) = 8.89.

TEXT function in the above formula will be the data in A1 rounded to two decimal places.

④=MROUND(A1,0.005)=8.88.

The MROUND function in the above formula rounds the data in A1 to two decimal places.

⑤FLOOR/FLOOR.MATH,CEILING/CEILING.MATH and so on.

Functions are related to inequalities and equations (elementary functions). By making the value of the function equal to zero, the value of the corresponding independent variable is, geometrically, the transverse coordinate of the intersection of the image with the X-axis; algebraically, the corresponding independent variable is the solution of the equation. In addition, replace “=” with “<” or “>” in the expression of the function (except for functions without expressions), and then replace “Y ” for other algebraic equations, the function becomes an inequality and you can find the range of the independent variable.