반응형
엑셀에서 유효자리수 맞추기
=ROUND(value,sigfigs-(1+INT(LOG10(ABS(value)))))
value :: the number you wish to round.
sigfigs :: the number of significant figures you want to round to.
https://www.vertex42.com/ExcelTips/significant-figures.html
Rounding to Significant Figures in Excel
How do you tell Excel to round to a specific number of significant figures without having to use exponential notation? This Excel formula will do the trick: =ROUND(value,sigfigs-(1+INT(LOG10(ABS(value))))) value :: the number you wish to round. sigfigs ::
www.vertex42.com
반응형
'엑셀' 카테고리의 다른 글
| equalize x_axis and y_axis scale (0) | 2023.04.04 |
|---|---|
| 엑셀 반올림 3사4입 (0) | 2023.04.03 |
| 엑셀 빼기 연산 오류 (0) | 2023.03.15 |
| 열너비와 행높이를 같게 만드는 방법 (0) | 2023.02.16 |
| 수량의 합을 만족하는 해 찾기 (0) | 2023.02.14 |