Reference library3 entries

Category: Tools & code

Guides and reference for implementing precision and rounding rules in software, spreadsheets, calculators, and markup languages.

Significant Figures in Excel, Sheets, Python, R, and Calculators: A Precision Reference

Learn how different software tools handle significant figures and rounding, with standards citations, worked examples, and common pitfalls to avoid.

Read explanation

Rounding to Significant Figures in Python: Precision, Pitfalls, and Best Practices

Learn how to round numbers to a specified number of significant figures in Python, including the pitfalls of binary floating-point, banker's rounding, and standards-based…

Read explanation

How to Round to Significant Figures in Excel (ROUND + LOG10 Method)

Learn the exact Excel formula to round any number to a specified number of significant figures using ROUND and LOG10, with worked examples, standards…

Read explanation