Reference library8 entries

Category: Excel

Rounding and significant figure functions and formulas in Microsoft Excel.

How to Propagate Uncertainty in Excel: A Step-by-Step Guide Using Formulas

Excel can propagate measurement uncertainty with the GUM law of propagation. This guide shows formulas for independent and correlated inputs, worked examples, and reporting…

Read explanation

Keeping Leading Zeros in Excel: A Guide for Measurement Data

Learn how to preserve leading zeros in Excel to maintain measurement precision and data integrity, ensuring compliance with ISO and NIST standards.

Read explanation

How to Make Excel Respect Sig Fig Rules: A Custom Rounding Formula

Excel lacks a native significant-figures function. Use a custom ROUND formula with LOG10, ABS, and INT to round to any number of significant figures…

Read explanation

How to Round to Significant Figures in Excel and Google Sheets

Learn the authoritative methods for implementing significant figure rounding in spreadsheet software using mathematical formulas and precision standards.

Read explanation

Scientific Notation in Excel: A Precision Guide for Formatting and Sig Figs

A comprehensive guide on managing scientific notation in Excel while maintaining rigorous significant figure standards and avoiding common floating-point errors.

Read explanation

How to Enter Scientific Notation in Excel, Google Sheets, and Python Without Losing Significant Figures

To enter scientific notation without losing significant figures, use numeric E-notation for calculation, custom formats or TEXT for display, and Decimal or text when…

Read explanation

How to Calculate Percent Error in Excel (and Avoid Rounding Errors)

Percent error in Excel is calculated as =ABS(experimental-expected)/ABS(expected), then formatted as a percentage or multiplied by 100. Keep full precision, round only the final…

Read explanation

Significant Figures in Excel: How to Round to a Given Number of Sig Figs

Excel has no built-in significant-figures function, but you can round to n sig figs with a formula using ROUND, LOG10, and ABS; understanding Excel's…

Read explanation