Reference library4 entries

Category: Excel

Rounding and significant figure functions and formulas in Microsoft Excel.

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