통계 clinical trial/Excel
소수점자리에 0 넣기 함수 (Fixed 함수)
고향이안드로메다
2019. 1. 30. 21:00
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자리..
