ROUNDUP,ROUNDDOWN
| 입력 | 표시 | 수식 |
| 987654321.12345 | 987654321.13000 | =ROUNDUP(A5,2) |
| 987654321.12345 | 987654400.00000 | =ROUNDUP(A5,-2) |
| 987654321.12345 | 987654322.00000 | =ROUNDUP(A5,0) |
| 987654321.12345 | 987654321.12345 | =ROUNDUP(A5,5) |
| 987654321.12345 | 987660000.00000 | =ROUNDUP(A5,-4) |
| 987654321.12345 | 987654321.12000 | =ROUNDDOWN(A5,-2) |
| 987654321.12345 | 987654321.00000 | =ROUNDDOWN(A5,0) |
| 987654321.12345 | 987654300.00000 | =ROUNDDOWN(A5,2) |
| 987654321.12345 | 987654321.12345 | =ROUNDDOWN(A5,5) |
| 987654321.12345 | 987650000.00000 | =ROUNDDOWN(A5,-4) |
'업무 향상 ★… > 【 엑 셀 함 수 】' 카테고리의 다른 글
| find (0) | 2012.01.16 |
|---|---|
| countblank (0) | 2012.01.13 |
| 엑셀 셀서식 - 금액(숫자)형식 (0) | 2011.12.07 |
| 엑셀 셀서식 - 날자, 시간 형식 지정 (0) | 2011.12.05 |
| HLOOKUP (0) | 2011.06.23 |