Data

1234.567

-1234.567

44.332

Formula

Description

Result

=FIXED(A2, 1)

Rounds the number in A2 one digit to the right of the decimal point.

1,234.6

=FIXED(A2, -1)

Rounds the number in A2 one digit to the left of the decimal point.

1,230

=FIXED(A3, -1, TRUE)

Rounds the number in A3 one digit to the left of the decimal point, without commas (the TRUE argument).

-1230

=FIXED(A4)

Rounds the number in A4 two digits to the left of the decimal point.

44.33


소수점 3자리..

블로그 이미지

고향이안드로메다

,